Sets the parameter values for a command using an associative array.

Syntax

---

edb_setparams(<CommandHandle>, <Values>)

<CommandHandle> =

Handle of command returned by edb_prepare function

<Values> = Associative array of parameter names and values

Returns

---

TRUE if successful, or FALSE if there are any errors

Usage

---

The edb_setparams function sets the parameter values for a command using an associative array of parameter names (as the keys) along with the parameter values.

Examples

---

<?php

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

var_dump(edb_getparams($cmd));

edb_disconnect($con);
?>