最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php事务回滚简单实现方法示例
时间:2017-08-03 编辑:简简单单 来源:一聚教程网
代码如下 | 复制代码 |
$servername = "localhost" ; $username = "root" ; $password = "admin" ; $dbname = "test" ; try { $conn = new PDO( "mysql:host=$servername;dbname=$dbname" , $username , $password ); $conn ->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); //开始事务 $conn ->beginTransaction(); $conn -> exec ( "INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('YE','XIAMING','yexianming@163.com')" ); $conn -> exec ( "INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('YE','CONG','yecong@163.com')" ); $conn -> exec ( "INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('FANG','MENG','fangmeng@168.com')" ); //提交事务 $conn ->commit(); echo "New records created successfully!" ; //回滚事务 $conn ->rollBack(); echo $sql . " . $e ->getMessage(); } $conn =NULL; |
相关文章
- 简单谈谈PHP中的trait 05-04
- 简单分析PHP中序列化用法介绍 08-27
- PHP中简单实现数学组合算法 01-09
- 简单的Thinkphp快速入门教程 12-12
- PHP新手算法 九九乘法表简单代码 10-30
- 一道简单的PHP笔试题(进阶必备) 09-12