Multiple prepared statements and preparing a stored procedure...
| From: | Ken Keefe | Date: | Tue, 05 Jun 2007 18:14:49 +0000 |
| Subject: | Multiple prepared statements and preparing a stored procedure... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43660@lists.php.net to get a copy of this message | ||
Is it possible to have multiple prepared statements associated with a
single mysqli object at one time?
For example:
$db = new mysqli($sqlServer, $sqlUser, $sqlPass, $sqlDB);
$query1 = $db->prepare($sql1);
$query2 = $db->prepare($sql2);
foreach ($arr as $key => $val)
if($val)
{
$query1->bind_param("s", $key);
$query1->execute();
}
else
{
$query2->bind_param("s", $key);
$query2->execute();
}
$query1->close();
$query2->close();
Also, is there any benefit to using a prepared statement to call a
stored procedure? If so, how do I prepare another statement after the
stored procedure? I keep getting an error about being out of sync...
Thanks,
Ken