PHP MySQL多重语句的样板代码

esanweb

于 2020-05-07 20:32:29 发布

阅读量204

点赞数

分类专栏： php 文章标签： mysql

本文链接：https://blog.csdn.net/esanweb/article/details/105980853

版权

php 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

<?php
$mysqli = new mysqli("localhost","root","root","world");

$query = "SELECT Name FROM City;";
$query .= "SELECT Name FROM Country;";

if($mysqli->multi_query($query)){
    do{
        if($result = $mysqli->store_result()){
            while($row = $result->fetch_row()){
                printf("Col: %s<br />", $row[0]);
            }
            $result->close();
        }
        echo "<hr />";
    } while ($mysqli->more_results() && $mysqli->next_result());
}
$mysqli->close();

注意while条件的写法while ($mysqli->more_results() && $mysqli->next_result())，按书中的写法会报错．