![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 PHP Extension Manual » Command Functions » edb_paraminfo |
edb_paraminfo(<CommandHandle>, <ParamNumber> | <ParamName>) <CommandHandle> = Handle of command returned by edb_prepare function <ParamNumber> = Ordinal position of parameter <ParamName> = Name of parameter
Associative array of parameter information if successful, or FALSE if there are any errors
| Key | Description |
| Name | The name of the parameter |
| Type | The 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) |
| DataType | The 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. |
| Collation | The collation for any CHAR/VARCHAR/CLOB parameter. For a list of valid collations in ElevateDB, please see the Collations system information table. |
| Length | The length of a CHAR/VARCHAR/BYTE/VARBYTE parameter. |
| Scale | The scale of a DECIMAL/NUMERIC parameter. |
<?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);
?>This web page was last updated on Tuesday, September 16, 2025 at 04:56 PM | Privacy Policy © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? |

