Icon edb_setparam

Sets the parameter value for a given parameter.

Syntax
edb_setparam(<CommandHandle>,
             <ParamNumber> | <ParamName>,
             <Value>)

<CommandHandle> =

Handle of command returned by edb_prepare function

<ParamNumber> = Ordinal position of parameter

<ParamName> = Name of parameter

<Value> = Any valid value

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

Usage
The edb_setparam function sets the value of the specified parameter.

Examples
<?php

// The following script connects to an ElevateDB
// Server and database, prepares a parameterized
// SELECT statement, sets the parameter value
// using the edb_setparam() function, and then
// displays the parameter value using the
// edb_getparam() 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_setparam($cmd,"State","FL");

echo edb_getparam($cmd,"State");

edb_disconnect($con);
?>
Image