<?php
header('content-type:text/html;charset=utf-8');
//实例化pdo
$pdo=new PDO('mysql:host=localhost;dbname=optimize','root','root');
//设置报错模式
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$pdo->exec('set names utf8');//设置字符集
try{
//开启事务
$pdo->beginTransaction();
//sql语句
$sql="update money set money=money+100 where `name`='张三'";
$sql2="update money set money=money-100 where `name`='李四'";
//判断pdo的执行结果
if($pdo->exec($sql)&&$pdo->exec($sql2)){
$pdo->commit();
}
}catch(PDOException $e){
echo $e->getMessage();//错误提示
$pdo->rollBack();//操作失败,事务回滚
}
?>
header('content-type:text/html;charset=utf-8');
//实例化pdo
$pdo=new PDO('mysql:host=localhost;dbname=optimize','root','root');
//设置报错模式
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$pdo->exec('set names utf8');//设置字符集
try{
//开启事务
$pdo->beginTransaction();
//sql语句
$sql="update money set money=money+100 where `name`='张三'";
$sql2="update money set money=money-100 where `name`='李四'";
//判断pdo的执行结果
if($pdo->exec($sql)&&$pdo->exec($sql2)){
$pdo->commit();
}
}catch(PDOException $e){
echo $e->getMessage();//错误提示
$pdo->rollBack();//操作失败,事务回滚
}
?>