//出现中文,设置header
header("Content-type:text/html;charset=utf-8");
try {
//pdo链接数据库
$pdo = new PDO("mysql:host=localhost;dbname=test","root","root");
//pdo事物开始
$pdo->beginTransaction();$sql = 'UPDATE `user` SET sex = 3 WHERE id=3';
//pdo sql执行
$res = $pdo->exec($sql);if(!$res){
//失败,抛出异常
throw new Exception("第一修改失败");}
$sql = 'UPDATE `user` SET sex = 3 WHERE id=2';
$res1 = $pdo->exec($sql);
if(!$res1){
throw new Exception("第二修改失败");
}
//pdo 执行
$pdo->commit();} catch (Exception $e) {
//pdo 回滚
$pdo->rollBack();
//输出异常
echo $e->getMessage();}