使用mysqli一次执行多条SQL语句

<?php
    $mysqli=new MySQLi("localhost","root","","xiaoqiangdb");
    
    /*==========================没有结果集:insert update delete==========================*/
    $sqls="insert into shops(name,price,num,desn) values('book1','12.16','5','good');";
    $sqls.="updated shops set name='testname' where id>50;";
    $sqls.="delete from shops where id < 20";
    
    if($mysqli->multi_query($sqls)){
        echo "多条语句执行成功!<br>";    
        echo "最后插入的ID:".$mysqli->insert_id."<br>";
        //echo "影响的行数:".$mysqli->affected_rows;  //不准确!
    }else{
        echo "ERROR".$mysqli->errno."---".$mysqli->error;
    }
    
    
    
    /*==========================有结果集:select==========================*/
    $sqls="select current_user();";
    $sqls.="desc shops;";
    $sqls.="select * fron shops";
    
    if($mysqli->multi_query($sqls)){
        echo "多条语句执行成功!<br>";
        do{
            $result=$mysqli->store_result();   //获取结果集
            
            echo '<table border="1" align="center">';
            echo '<tr>';
            while($field=$result->fetch_field()){
                echo '<th>'.$field->name.'</th>';
            }
            echo '</tr>';
            
            while($row=$result->fetch_assoc()){
                echo '<tr>';
                foreach($row as $col){
                    echo '<td>'.$col.'&nbsp;</td>';
                }
                echo '</tr>';
            }
            echo '</table>';
            
            if($mysqli->more_results()){   //判断还有没有结果集
                echo "<br><br><br>";    
            }
            
        }while($mysqli->next_result());    //取得下一个结果集
    }else{
        echo "ERROR".$mysqli->errno."---".$mysqli->error;
    }
    
    
    $mysqli->close();

?>