mysqli批量执行语句

来源：互联网发布：mac php环境编辑：程序博客网时间：2024/06/05 09:03

<?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();?>

阅读全文

0 0