Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 PHP Extension Manual » Cursor Functions » edb_colinfo |
edb_colinfo(<CursorHandle>, <ColumnNumber> | <ColumnName>) <CursorHandle> = Handle of cursor returned by edb_execute function <ColumnNumber> = Ordinal position of column <ColumnName> = Name of column
Associative array of column information if successful, or FALSE if there are any errors
Key | Description |
Name | The name of the column |
DataType | The data type of the column, which can be any of the valid ElevateDB data types. For a list of valid data types in ElevateDB, please see the DataTypes system information table. |
Collation | The collation for any CHAR/VARCHAR/CLOB column. For a list of valid collations in ElevateDB, please see the Collations system information table. |
Length | The length of a CHAR/VARCHAR/BYTE/VARBYTE column. |
Scale | The scale of a DECIMAL/NUMERIC column. |
Nullable | Whether or not the column is nullable. |
<?php // The following script connects to an ElevateDB // Server and database, prepares a parameterized // SELECT statement, executes the statement, and // then displays the cursor column information // using the var_dump() function $con = edb_connect("type=remote;charset=Ansi;address=127.0.0.1;"+ "uid=Administrator;pwd=EDBDefault;database=Test"); if (!$con) { die("Could not connect: " . edb_errmsg()); } $cmd = edb_prepare($con,"SELECT State, COUNT(State) AS Total FROM customer GROUP BY State"); $cursor = edb_execute($cmd); var_dump(edb_colinfo($cursor,"Total")); edb_disconnect($con); ?>
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |