1. $servername="localhost"; 
2.     $username="root"; 
3.     $password="admin"; 
4.     $dbname="test"; 
5.     try{ 
6.       $conn=new PDO("mysql:host=$servername;dbname=$dbname",$username,$password); 
7.       $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); 
8.       //开始事务 
9.       $conn->beginTransaction(); 
10.       $conn->exec("INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('YE','XIAMING','yexianming@163.com')"); 
11.       $conn->exec("INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('YE','CONG','yecong@163.com')"); 
12.       $conn->exec("INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('FANG','MENG','fangmeng@168.com')"); 
13.       //提交事务 
14.       $conn->commit(); 
15.       echo "New records created successfully!"; 
16.     }catch(PDOException $e){ 
17.        //回滚事务 
18.        $conn->rollBack(); 
19.        echo $sql." 
20. ".$e->getMessage(); 
21.     } 
22.     $conn=NULL; 

Tags: 示例 事务 方法

分享到：