note 71439 added to function.mysqli-stmt-prepare

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-prepare.php Edit -- https://master.php.net/note/edit/71439 Del: integrated -- https://master.php.net/note/delete/71439/integrated Del: useless -- https://master.php.net/note/delete/71439/useless Del: bad code -- https://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 -- https://master.php.net/note/delete/71439/in+docs Del: other reasons-- https://master.php.net/note/delete/71439 Reject -- https://master.php.net/note/reject/71439 Search -- https://master.php.net/manage/user-notes.php