PDO事物处理

最新推荐文章于 2023-12-16 17:58:51 发布

xueling022

最新推荐文章于 2023-12-16 17:58:51 发布

阅读量402

点赞数

文章标签： pdo sql utf-8 exception

本文链接：https://blog.csdn.net/xueling022/article/details/49947273

版权

<?php
header("Content-Type:text/html;charset=utf-8");

//$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$sql =<<<SQL
CREATE TABLE user_account(
id int unsigned not null auto_increment comment '主键ID',
username varchar(30) not null comment '用户名',
money DECIMAL(10, 2) not NULL comment '用户余额',
PRIMARY KEY (id)
)engine=MYISAM;
SQL;
$pdo->exec($sql);

$sql = "INSERT INTO user_account(username, money) VALUES ('zhangsan', 10000)";
$pdo->exec($sql);
$sql = "INSERT INTO user_account(username, money) VALUES('lisi', 5000)";
$pdo->exec($sql);

try{
    $user = "user";
    $pwd = "pwd";
    $options = array(PDO::ATTR_AUTOCOMMIT, 0); // 关闭事物自动提交功能
    $pdo = new PDO("mysql:dbname=test;host=127.0.0.1", $user, $pwd, $options); // 链接PDO

    $pdo->beginTransaction(); // 开启事物
    $sql = "UPDATE user_account SET money = money - 500 WHERE id = 1"; //张三每次减少500
    $res = $pdo->exec($sql);
    if($res==0){ // 如果实行失败抛出异常, 事物回滚
        throw new PDOException(" transfer account error");
    }

    $sql = " UPDATE user_account SET money=money + 2000 WHERE id = 6 ";
    $res1 = $pdo->exec($sql);
    if($res1 == 0){
        throw new PDOException("李四 not transfer account info");
    }
    $pdo->commit(); // 全部执行成功,提交事物
}catch (PDOException $e){
    $pdo->rollBack(); // 失败, 事物回滚
    echo $e->getMessage();
}