PHP 中的 mysqli multi query函数

mysqli multi query - 语法

bool mysqli_multi_query ( mysqli $link , string $query );

它用于对数据库使用分号分隔查询。

mysqli multi query - 返回值

成功时返回TRUE，失败时返回FALSE。

无涯教程网

mysqli multi query - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","pass","db");
   
   if (mysqli_connect_errno($connection_mysql)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
   
   $sql="SELECT Lastname FROM Persons;SELECT Country FROM Customers";
   
   if (mysqli_multi_query($connection_mysql,$sql)){
      do{
         if ($result=mysqli_store_result($connection_mysql)){
            while ($row=mysqli_fetch_row($result)){
               printf("%s\n",$row[0]);
            }
            mysqli_free_result($connection_mysql);
         }
      }while (mysqli_next_result($connection_mysql));
   }
   mysqli_close($connection_mysql);
?>