<?php
header("content-type:text/html;charset=utf-8");
$dsn = "mysql:host=localhost;dbname=test";
$pdo = new PDO($dsn,'root','123456');
try {
$pdo->beginTransaction(); //开启一个时务
$sql = 'update user set pwd = pwd +1 where user = "jiang" ';
$row = $pdo -> exec($sql);
if(!$row) throw new PDOException("加钱失败~");
$sql = 'update uer set pwd = pwd -1 where user = "feng" ';
$row = $pdo -> exec($sql);
if(!$row) throw new PDOException("减钱失败~");
$pdo->commit();
} catch (PDOException $e){
echo $e->getMessage();
}
header("content-type:text/html;charset=utf-8");
$dsn = "mysql:host=localhost;dbname=test";
$pdo = new PDO($dsn,'root','123456');
try {
$pdo->beginTransaction(); //开启一个时务
$sql = 'update user set pwd = pwd +1 where user = "jiang" ';
$row = $pdo -> exec($sql);
if(!$row) throw new PDOException("加钱失败~");
$sql = 'update uer set pwd = pwd -1 where user = "feng" ';
$row = $pdo -> exec($sql);
if(!$row) throw new PDOException("减钱失败~");
$pdo->commit();
} catch (PDOException $e){
echo $e->getMessage();
}