Batch execution of MySQL operations in PHP, and get batch results

 
 Multi_query ($sql)) {do{//takes a result set from $mysqli this link $result= $mysqli->store_result ();//extract data from the result set while ($rows = $result- >fetch_row ()) {foreach ($row as $key = $val) {echo  "$key----$val";} echo "
";} Release the resource $result->free ();//Determine if there is a result set below, no then jump out if (! $mysqli->more_results ()) {break;} Take out the next result set,//But Next_result () This method has the disadvantage of not being able to determine whether the next result set exists, empty It is also taken out.  }while ($mysqli->next_result ());} Close resources, in general, the link is the system itself over time disconnected, here is not immediately cut off $mysqli->close (); >

