note 129326 added to mysqli.multi-query
| From: | brice.php@radium.fr | Date: | Mon, 11 Mar 2024 03:32:21 +0000 |
| Subject: | note 129326 added to mysqli.multi-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221241@lists.php.net to get a copy of this message | ||
// To drop the results of a multi_query, here is a solution that works:
$query = "myquery 1; myquery 2; myquery 3";
if($mysqli->multi_query($query)) {
do {
if ($result=$mysqli->store_result()) $result->free();
} while ($mysqli->more_results() && $mysqli->next_result());
}
// and what is below will work
$mysqli->query("myquery");
// that's all
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.13.131 (proxied: 176.139.82.42)
----
Manual Page -- https://php.net/manual/en/mysqli.multi-query.php
Edit -- https://main.php.net/note/edit/129326
Del: integrated -- https://main.php.net/note/delete/129326/integrated
Del: useless -- https://main.php.net/note/delete/129326/useless
Del: bad code -- https://main.php.net/note/delete/129326/bad+code
Del: spam -- https://main.php.net/note/delete/129326/spam
Del: non-english -- https://main.php.net/note/delete/129326/non-english
Del: in docs -- https://main.php.net/note/delete/129326/in+docs
Del: other reasons-- https://main.php.net/note/delete/129326
Reject -- https://main.php.net/note/reject/129326
Search -- https://main.php.net/manage/user-notes.php