Icon edb_paraminfo

Returns information about a given parameter as an associative array.

Syntax
edb_paraminfo(<CommandHandle>, <ParamNumber> | <ParamName>)

<CommandHandle> =

Handle of command returned by edb_prepare function

<ParamNumber> = Ordinal position of parameter

<ParamName> = Name of parameter

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

Usage
The edb_paraminfo function returns the following information about the specified parameter:

KeyDescription
NameThe name of the parameter
TypeThe type of the parameter, which can be one of the following:
EDB_PARAM_INPUT_TYPE (1)
EDB_PARAM_OUTPUT_TYPE (2)
EDB_PARAM_INPUTOUTPUT_TYPE (3)
EDB_PARAM_RESULT_TYPE (4)
DataTypeThe data type of the parameter, 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 parameter. For a list of valid collations in ElevateDB, please see the Collations system information table.
LengthThe length of a CHAR/VARCHAR/BYTE/VARBYTE parameter.
ScaleThe scale of a DECIMAL/NUMERIC parameter.

Examples
<?php

// The following script connects to an ElevateDB
// Server and database, prepares a parameterized
// SELECT statement, and then displays the parameter
// 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 * FROM customer WHERE State=:State");

var_dump(edb_paraminfo($cmd,"State"));

edb_disconnect($con);
?>
Image