<?php
//执行多条sql语句
header('content-type:text/html,charset=utf8');
$mysqli=new mysqli('localhost','root','','test');
if($mysqli->errno)
{
die('Connect Error'.$mysqli->error);
}
$mysqli->set_charset('utf8');
$sql="INSERT user (username,password,age) VALUES('imooc2','imooc2','12');";
$sql.="UPDATE user SET age=100 WHERE id=31;";
$sql.="DELETE FROM user WHERE id=30;";
//针对多条SQL语句的查询
//他的返回值只跟第一条语句有关,不管后两条语句如何
//如果第一条语句错误,后两条语句不会执行,sql语句引号里面以分号隔开
//$mysqli->query($sql);
$res=$mysqli->multi_query($sql);
var_dump($res);