最新下载
热门教程
- 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','[email protected]')" ); $conn -> exec ( "INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('YE','CONG','[email protected]')" ); $conn -> exec ( "INSERT INTO `hello`(`firstname`,`lastname`,`email`)VALUES('FANG','MENG','[email protected]')" ); //提交事务 $conn ->commit(); echo "New records created successfully!" ; //回滚事务 $conn ->rollBack(); echo $sql . " . $e ->getMessage(); } $conn =NULL; |
相关文章
- 和平精英PC模拟器怎么切换投掷武器-投掷物切换方法 08-14
- 和平精英PC模拟器ui怎么换回原来的-新旧UI切换方法 08-14
- 和平精英PC模拟器怎么唤出鼠标-鼠标唤出键位介绍 08-14
- 和平精英PC模拟器画质怎么调最清晰-画质设置教程 08-14
- 和平精英PC模拟器配置要求高吗-配置要求介绍 08-14
- 和平精英PC模拟器能和手机一起玩吗-多平台匹配机制介绍 08-14