| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 2.5.0b5 |
| Request #6418 | mysqli_multi_query and procedures | ||
|---|---|---|---|
| Submitted: | 2006-01-05 11:45 UTC | ||
| From: | akg1 at fmu1 dot net | Assigned: | lsmith |
| Status: | Closed | Package: | MDB2 |
| PHP Version: | 5.0.5 | OS: | Linux |
| Roadmaps: | (Not assigned) | ||
[2006-01-05 11:45 UTC] akg1 at fmu1 dot net
Description:
------------
Implementation to execute multiple stored procedures per one connection.
Problem about using mysqli->query can be found here:
http://bugs.php.net/bug.php?id=35203
http://bugs.php.net/bug.php?id=35333
So use of multi_query is needed.
Test script:
---------------
Sample script, when no results are needed:
for($i=0; $i<3; $i++)
{
//asuming we have a valid mysqli object
if (!$mysqli->multi_query("call someStoredProc(1)"))
{
printf("Error: %s\n", $mysqli->error);
}
else
{
do
{
if ($result = $mysqli->store_result())
{
$result->close();
}
} while ($mysqli->next_result());
}
}
This, however will cause an error:
for($i=0; $i<3; $i++)
{
//asuming we have a valid mysqli object
if (!$mysqli->multi_query("call someStoredProc(1)"))
{
printf("Error: %s\n", $mysqli->error);
}
else
{
$result = $mysqli->store_result())
$result->close();
}
}
Comments
[2006-01-12 17:26 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-01-12 18:00 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!