![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 PHP Extension Manual » Command Functions » edb_setparamtype |
edb_setparamtype(<CommandHandle>,
<ParamNumber> | <ParamName>,
<ParamType>)
<CommandHandle> =
Handle of command returned by edb_prepare function
<ParamNumber> = Ordinal position of parameter
<ParamName> = Name of parameter
<ParamType> = EDB_PARAM_INPUT_TYPE (1) |
EDB_PARAM_OUTPUT_TYPE (2) |
EDB_PARAM_INPUTOUTPUT_TYPE (3) |
EDB_PARAM_RESULT_TYPE (4)TRUE if successful, or FALSE if there are any errors
| Type | Description |
| EDB_PARAM_INPUT_TYPE (1) | The parameter is an input parameter |
| EDB_PARAM_OUTPUT_TYPE (2) | The parameter is an output parameter |
| EDB_PARAM_INPUTOUTPUT_TYPE (3) | The parameter is both and input and output parameter |
| EDB_PARAM_RESULT_TYPE (4) | The parameter is a result parameter (functions) |
<?php
// The following script connects to an ElevateDB
// Server and database, prepares a parameterized
// SELECT statement, and then sets the parameter
// type using the edb_setparamtype() 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");
edb_setparamtype($cmd,"State",EDB_PARAM_INPUT_TYPE);
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 ? |

