note 113840 added to mysqli.multi-query

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

« previous php.notes (#197830) next »