pdo提交事务 数据库连接成功.ATUOCOMMIT修改为0后$stmt返回0

Question

<?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();

}

?>

Answer 1

我知道了 是因为含中文  我没有 $pdo->exec('set names utf8');