Do not try to use a stored procedure through a prepared
statement.
Example:
<?php
$statement = $mysqli->stmt_init();
$statement->prepare("CALL some_procedure()");
?>
If you attempt to do this, it will fail by dropping the
connection during the next query. Use mysqli_multi_query
instead.
Example:
<?php
$mysqli->multi_query("CALL some_procedure()");
do
{
$result = $mysqli->store_result();
// Do your processing work here
$result->free();
} while($mysqli->next_result());
?>
This means that you cannot bind parameters or results,
however.
----
Server IP: 203.220.0.234
Probable Submitter: 203.26.206.129 (proxied: 121.44.140.93)
----
Manual Page -- http://www.php.net/manual/en/function.mysqli-stmt-p
repare.php
Edit -- https://master
.php.net/note/edit/71439
Del: integrated -- h
ttps://master.php.net/note/delete/71439/integrated
Del: useless -- http
s://master.php.net/note/delete/71439/useless
Del: bad code -- htt
ps://master.php.net/note/delete/71439/bad+code
Del: spam -- https:/
/master.php.net/note/delete/71439/spam
Del: non-english --
https://master.php.net/note/delete/71439/non-english
Del: in docs -- http
s://master.php.net/note/delete/71439/in+docs
Del: other reasons-- https://mast
er.php.net/note/delete/71439
Reject -- https://mast
er.php.net/note/reject/71439
Search -- https://
master.php.net/manage/user-notes.php
--
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php
|