$db->query("SET AUTOCOMMIT=0"); // 关闭自动提交 开启事务
$sql1 = "delete from " . $ecs->table('cshop') . " where user_id = '$_SESSION[user_id]' ";
$res1 = $db->query($sql1);
$sql2 = "delete from " . $ecs->table('cshop_gadd') . " where user_id = '$_SESSION[user_id]' ";
$res2 = $db->query($sql2);
$sql3 = "delete from " . $ecs->table('cshop_gedit') . " where user_id = '$_SESSION[user_id]' ";
$res3 = $db->query($sql3);
if ($res1 && $res2 && $res3) { // 全部又返回值 则 commit;
$db->query("COMMIT");
echo json_encode(array('res'=>1,'code'=>'success','msg'=>'删除成功!'));
}else{ // 有一个出错 则 rollback;
$db->query("ROLLBACK");
echo json_encode(array('res'=>0,'code'=>'error','msg'=>'删除失败!'));
}
$db->query("SET AUTOCOMMIT=1"); // 开启自动提交 开启事务
ecshop中 简单 事务处理 (实例) 表储存引擎 innoDB
最新推荐文章于 2018-12-14 14:46:31 发布