Login ProductsSalesSupportDownloadsAbout |
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 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 |