最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php事务回滚简单实现方法示例
时间:2022-06-24 14:43:53 编辑:袖梨 来源:一聚教程网
代码如下 | 复制代码 |
$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; |
相关文章
- 逆水寒手游橙戒流火幻荧什么时候上线 04-25
- 原神仆人阵容搭配推荐 04-25
- 恶意不息铁匠铺怎么升级 04-25
- 原神龙蜥特急斯库拉号成就怎么达成 04-25
- 恶意不息浅滩双子掉落什么 04-25
- 原神仆人阿蕾奇诺武器推荐 04-25