php mysqli multiple query example

Examples of Mysqli multiple queries in php, interested friends can refer to it.

mysqli_multi_query(mysqli link,string query) executes multiple queries continuously and is based on process msyqli_more_results(mysqli link) mainly determines whether the returned result set has other result sets mysqli_next_result(mysqli link) Get the next result set

Example:

 #Connect to database
 $link=mysqli_connect("localhost","root","root");
 #Select database
 $link->select_db("rorely ") or die("could not find database");
 #Query database
 if($link->multi_query("select * from test;select name ,age ,sex,address from test")){
 do{
 $result=$link->store_result();
 while($row=$result->fetch_row()){
 echo "$row[0],$row[1],$row[2], $row[3]";
 }
 if($link->more_results()) echo "**********";
 }while($link- >next_result());
 }
$link->close();
?>

The results are as follows: 1,Jane,26,female 3,Tome,21,male 4,Lily,25,female 5,Lucy,25,female 6,Jim,22,male 7,Jim,22,male ********** Jane,26,female,wenming cun 123# Tome,21,male,wenming cun 32# Lily,25,female,wenming cun 2# Lucy,25,female,wenming cun 2# Jim,22,male,wenmin cun 45# Jim,22,male,wenmin cun 45# li,22,female,wenming cun 23# hj,30,male,wenming cun 23# hj,30,male,wenming cun 23#