MySql批量执行dql语句(PHP)

<?php

    $mysqli=new MySQLi("localhost","root","root","database");
    if($mysqli->connect_error){
        die($mysqli->connect_error);
    }

    //定义多条sql查询语句
    $sqls="sql语句1";
    $sqls.="sql语句2";
    $sqls.="sql语句3";
    
    //............//

    //批量执行sql查询语句
    if($res=$mysqli->multi_query($sqls)){
        do{
            //从mysqli连接中取出第一个结果集
            $result=$mysqli->store_result();

            //显示mysqli result对象
            while($row=$result->fetch_row()){
                foreach($row as $key=>$val){
                    echo "$val";
                }

                //及时释放资源
                $result->free();

                //判断是否有结果集
                if(!$mysqli->more_results()){
                    break;
                }

                echo "<br/>*******新的结果集*********<br/>";
            }while($mysqli->next_result());
        }

        $mysqli->close();

?>