<?php
header("Content-type:text/html;charset=utf-8");
@mysql_pconnect("localhost","root","") or die("数据库连接失败");
mysql_select_db("test");
mysql_query("set names utf8");
//开启一个事务
//mysql_query("BEGIN");
//mysql_query("START TRANSACTION");
//mysql_query("SET AUTOCOMMIT=1");//设置事务不自动提交 mysql默认是自动提交
mysql_query("START TRANSACTION");//开启事务
$sql1 = "INSERT INTO `china`values (NULL,'2222小贾','测试数据')";
$sql2 = "INSERT INTO `china` values (NULL,'111小刘','sss')";
$sql3 = "INSERT INTO `result` values (NULL,'赵六','体育',70)";
$res1 = mysql_query($sql1);
$res2 = mysql_query($sql2);
$res3 = mysql_query($sql3);
if($res1 && $res2 && $res3)
{
mysql_query("COMMIT");
echo "事务提交";
}else{
mysql_query("ROLLBACK");
echo "事务回滚";
}
mysql_query("END");
?> 最佳答案
