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();
?>
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 "*****新的结果集*****
";
$result=$mysqli->store_result();
while($row=$result->fetch_row())
{
foreach($row as $key=>$value)
{
echo "--$value";
}
echo "
";
}
$result->free();//释放结果集
if(!$mysqli->more_results()) //判断后面还有无结果集
break;
}while($mysqli->next_result());
}
$mysqli->close();
?>