<?php $mysqli=new mysqli("localhost","root","123456","test003"); if($mysqli->connect_error){ die ("LINK FAILED".$mysqli->connect_error); } $mysqli->query("set names utf8"); //关闭自动提交; $mysqli->autocommit(false); $sql01="update account set balance=balance+4 where id=1;"; $sql02="update account set balance=balance-4 where id=2;"; $b1=$mysqli->query($sql01) or die($mysqli->error); $b2=$mysqli->query($sql02) or die($mysqli->error); if(!$b1||!$b2){ echo "Failed".$mysqli->error; //回滚; $mysqli->rollback(); } else { echo "success"; //提交; $mysqli->commit(); } $mysqli->close();
Mysqli:事务回滚
最新推荐文章于 2023-02-06 14:45:47 发布