PHP基础之事务控制

$mysqli=new mysqli('localhost','root','','test');
	
	if($mysqli->connect_error){
		die("连接失败".$mysqli->connect_error);
		}
		
	$mysqli->query("set names utf8");
	$mysqli->autocommit ( FALSE );
	//$sql="alter table user ENGINE = InnoDB";
	$sql1="update user  username='xiaoming' where id=2";
	$sql2="update user set username='daming' where id=3";
	
	/* if($mysqli->query($sql)){
		echo "修改成功";
	} */
	
 	$b1=$mysqli->query($sql1);
	$b2=$mysqli->query($sql2);
	
	if(!$b1||!$b2){
		$mysqli->rollback();
		echo "回滚$mysqli->error";
	}else{
		echo "提交成功";
		$mysqli->commit();
	}
	
	$mysqli->close();