DB----事务处理 PHP

PHP 模式

$link = mysql_connect("localhost", "root", "");
mysql_query("set names utf8");

$sql = "start transaction;"       #开启一个事务
mysql _query($sql);

$sql1 = "update t1 set money = money - 5000 where uid='001'"
$result1 = mysql_query($sql1);

$sql2 = "update t1 set money = money + 5000 where uid='002'"
$result2 = mysql_query($sql2);

// 根据结果判断提交或回滚
if($result1 && $result2) {
	mysql_query("commit;");
    echo "事务执行成功";
}else {
	msyql_query("rollback;");
    echo "事务执行失败";
}