note 129326 added to mysqli.multi-query

From: 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

« previous php.notes (#221241) next »