note 113840 added to mysqli.multi-query
| From: | IvanGabriele | Date: | Sat, 07 Dec 2013 16:47:33 +0000 |
| Subject: | note 113840 added to mysqli.multi-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-197830@lists.php.net to get a copy of this message | ||
To be able to execute a $mysqli->query() after a $mysqli->multi_query() for MySQL > 5.3, I
updated the code of jcn50 by this one :
<?php
// WORKING CODE:
$mysqli->multi_query(" Many SQL queries ; "); // OK
while ($mysqli->next_result()) // flush multi_queries
{
if (!$mysqli->more_results()) break;
}
$mysqli->query(" SQL statement #1 ; ") // now executed!
$mysqli->query(" SQL statement #2 ; ") // now executed!
$mysqli->query(" SQL statement #3 ; ") // now executed!
$mysqli->query(" SQL statement #4 ; ") // now executed!
?>
----
Server IP: 72.52.91.14
Probable Submitter: 72.52.91.14
----
Manual Page -- http://php.net/manual/en/mysqli.multi-query.php
Edit -- https://master.php.net/note/edit/113840
Del: integrated -- https://master.php.net/note/delete/113840/integrated
Del: useless -- https://master.php.net/note/delete/113840/useless
Del: bad code -- https://master.php.net/note/delete/113840/bad+code
Del: spam -- https://master.php.net/note/delete/113840/spam
Del: non-english -- https://master.php.net/note/delete/113840/non-english
Del: in docs -- https://master.php.net/note/delete/113840/in+docs
Del: other reasons-- https://master.php.net/note/delete/113840
Reject -- https://master.php.net/note/reject/113840
Search -- https://master.php.net/manage/user-notes.php