Icon edb_colinfo

Returns information about a given cursor column as an associative array.

Syntax
edb_colinfo(<CursorHandle>, <ColumnNumber> | <ColumnName>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

<ColumnNumber> = Ordinal position of column

<ColumnName> = Name of column

Returns
Associative array of column information
if successful, or FALSE if there are any errors

Usage
The edb_colinfo function returns the following information about the specified column:

KeyDescription
NameThe name of the column
DataTypeThe 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.
CollationThe collation for any CHAR/VARCHAR/CLOB column. For a list of valid collations in ElevateDB, please see the Collations system information table.
LengthThe length of a CHAR/VARCHAR/BYTE/VARBYTE column.
ScaleThe scale of a DECIMAL/NUMERIC column.
NullableWhether or not the column is nullable.

Examples
<?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);
?>
Image