无涯教程-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</span><span class="pun">,</span><span class="pln">$sql)){
do{
if ($result</span><span class="pun">=</span><span class="pln">mysqli_store_result</span><span class="pun">(</span><span class="pln">$connection_mysql)){
while ($row</span><span class="pun">=</span><span class="pln">mysqli_fetch_row</span><span class="pun">(</span><span class="pln">$result)){
printf("%s\n",row</span><span class="pun">[</span><span class="lit">0</span><span class="pun">]);</span><span class="pln">
            </span><span class="pun">}</span><span class="pln">
            mysqli_free_result</span><span class="pun">(</span><span class="pln">connection_mysql);
}
}while (mysqli_next_result(connection_mysql</span><span class="pun">));</span><span class="pln">
   </span><span class="pun">}</span><span class="pln">
   mysqli_close</span><span class="pun">(</span><span class="pln">connection_mysql);
?>

参考链接

www.learnfk.com/php/php-mys…