<?php$dsn = 'mysql:dbname=cheyun_cms;host=127.0.0.1';$user = 'root';$password = '111111';//采用預處理+事務處理執行SQL操作//1.連接數據庫try {  $pdo = new PDO($dsn, $user, $password);  $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);} catch (PDOException $e) {  die("數據庫連接失敗".$e->getMessage());}//2.執行數據操作try{  //開啟事物,此時會關閉自動提交  $pdo->beginTransaction();  $sql = "insert into cy_log (logid, value, action, file) values (?, ?, ?, ?)";  $stmt = $pdo->prepare($sql);  //傳入參數  $stmt->execute(array(null,"test4","w",11));  $stmt->execute(array(null,"test5","w",11));  $stmt->execute(array(null,"test3","w",11));  //提交事物，并且 數據庫連接返回到自動提交模式  $pdo->commit();}catch(PDOException $e){  echo '執行失敗'.$e->getMessage();  //如果數據庫被設置成自動提交模式，rollback 在回滾事務之后將恢復自動提交模式。  //包括 MySQL 在內的一些數據庫， 當在一個事務內有類似刪除或創建數據表等 DLL 語句時，會自動導致一個隱式地提交。  //隱式地提交將無法回滾此事務范圍內的任何更改。即 DDL 語句無法回滾  $pdo->rollback();}

<?php$dsn = 'mysql:dbname=cheyun_cms;host=127.0.0.1';$user = 'root';$password = '111111';//采用預處理+事務處理執行SQL操作//1.連接數據庫try {  $pdo = new PDO($dsn, $user, $password);} catch (PDOException $e) {  die("數據庫連接失敗".$e->getMessage());}//2.執行數據操作//開啟事物$pdo->beginTransaction();$sql = "insert into cy_log (logid, value, action, file) values (?, ?, ?, ?)";$stmt = $pdo->prepare($sql);$datalist = array(  array(null,"test9","w",11),  array(null,"test10","w",11),  array(null,"test11","w",11));//是否提交標志位$isCommit = true;foreach($datalist as $data){  $stmt->execute($data);  if($stmt->errorCode()>0){    //回滾    $pdo->rollback();    $isCommit = false;    break;  }}if($isCommit){  //提交事物  $pdo->commit();}