PDO事务

转账的事务部分

<?php
$zid=$_POST['zid'];
$userid=$_POST['userid'];
$money=$_POST['money'];
//PDO链接数据库
$pdo=new PDO("mysql:host=127.0.0.1;dbname=1611d","root","root");
//开启事务
$pdo->beginTransaction();
//数据库修改操作
$smth1=$pdo->exec("update pay set money=money-$money where id='$zid'");
$smth2=$pdo->exec("update pay set money=money+$money where id='$userid'");
$res=$pdo->query("select * from pay where id='$zid'")->fetch();

$res1=$res['money'];
if($smth1>0&&$smth2>0){
//成功则提交
$pdo->commit();
echo 1;
}else if($res1<$money){
//失败返回事务
$pdo->rollBack();
echo 2;
}else{
$pdo->rollBack();
echo 3;
}