php 使用mysqli_multi_query函数执行多条SQL语句

mysqli_multi_query介绍

mysqli_multi_query() 函数执行一个或多个针对数据库的查询。多个查询用分号进行分隔。

语法：

mysqli_multi_query(connection,query);

参数：

mysqli_multi_query实例

使用mysqli_multi_query函数执行多条sql语句。

<?php
    $mysqli = new mysqli(\"localhost\", \"username\", \"password\",\"mydata \", 3306);

    $queries = \"SELECT * FROM mytable; SELECT * FROM anothertable\";

    if(mysqli_multi_query($mysqli, $queries)) {
        do {
            if($result = mysqli_store_result($mysqli)) {
                while($row = mysqli_fetch_row($result)) {
                    foreach($row as $key => $value) {
                        echo \"$key => $value<BR/>\\n\";        
                    }
                }
                mysqli_free_result($result);        
            }
            if(mysqli_more_results($mysqli)) {                
                echo \"<BR/>\\nNext result set<BR/>\\n\";
            }
        } while(mysqli_next_result($mysqli));
    }
    mysqli_close($mysqli);
?>