mysqli批量执行语句

<?php
//批量执行时可以混合执行delete，insert，update语句，但最好不要使用select
$mysqli=new mysqli('localhost','root','root','test');
if($mysqli->connect_error)
    die($mysqli->connect_error);
$mysqli->query("set names utf8");
$sql="insert into user1 (name,password,email,age) values ('傻子1',md5('asd'),'1234@qq.com','34');";
$sql.="insert into user1 (name,password,email,age) values ('傻子2',md5('attyyd'),'1934@qq.com','24');";
$sql.="insert into user1 (name,password,email,age) values ('傻子3',md5('3546d'),'13224@qq.com','46')";
$b=$mysqli->multi_query($sql);
if(!$b)
    echo "失败".$mysqli->error;
else
    echo "成功";
$sqls="delete from user1 where id=59;";
$sqls.="delete from user1 where id=60;";
$sqls.="delete from user1 where id=61";
$res=$mysqli->multi_query($sqls);
if(!$res==0)
    echo $mysqli->error;
else
    echo "成功2";
$mysqli->close();
?>

<?php
$mysqli=new mysqli('localhost','root','root','test');
if($mysqli->connect_error)
{
    die ("连接失败".$mysqli->error);
}
$mysqli->query("set names utf8");
$sqls="select * from user1;";
$sqls.="select * from words;";
$sqls.="desc user1";

//处理结果与关闭资源
if($res=$mysqli->multi_query($sqls))//如果成功则至少有一个结果集
{
    do{
        echo "*****新的结果集*****<br>";
        $result=$mysqli->store_result();
        while($row=$result->fetch_row())
        {
            foreach($row as $key=>$value)
            {
                echo "--$value";
            }
            echo "<br>";
        }
        $result->free();//释放结果集

        if(!$mysqli->more_results()) //判断后面还有无结果集
            break;
    }while($mysqli->next_result());
}
$mysqli->close();
?>