<?php $options=array(PDO::ATTR_AUTOCOMMIT,0); $pdo=new PDO("mysql:host=localhost;dbname=manage","","",$options); try{ $pdo->beginTransaction(); $sql= "update employee set age=age+500 where name = '王五'"; $stmt1=$pdo->exec($sql); var_dump($stmt1); if($stmt1==0){ throw new PDOException('添加失敗'); } $sql2="update employee set age=age-500 where name = '張三三'"; $stmt=$pdo->exec($sql2); if($stmt==0){ throw new PDOException('減少失敗'); } $pdo->commit(); }catch (PDOException $e){ $pdo->rollBack(); echo $e->getMessage(); }?>
pdo提交事務 數據庫連接成功.ATUOCOMMIT修改為0后$stmt返回0
幕布斯7510621
2016-07-28 10:36:00
