Icon edb_setparamtype

Sets the parameter type for a given parameter.

Syntax
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)

Returns
TRUE if successful, or FALSE if there are any errors

Usage
The edb_setparamtype function sets the type of the parameter as one of the following values:

TypeDescription
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)

Information Only INSERT SQL statements, scripts, or procedures/functions can have output or result parameters. In all but a few rare cases, you will never need to use this function.

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