thinkphp和mysql_thinkphp和php对mysql事务处理的示例

thinkphp 处理mysql事务示例：

$t1 = M('a');

$t2 = M('b');

$t1->startTrans();

$r1 = $t1->where('id = 1')->delete();

$r2 = $t2->where('id = 2')->delete();

if($res1 && $res2){

$model1->commit();   //$r1 和$res2 为真，则提交数据库的所有操作

dump("commit");

}else{

$t1->rollback();  //  条件不满足，回滚

dump("rollback");

}

exit;

php对mysql事务处理示例：

$conn = mysql_connect('127.0.0.1','t','t') or die('DB connection failed!');

mysql_select_db('a',$conn);

mysql_query('set names "GBK"');

mysql_query('BEGIN');

$sql1 = "INSERT INTO `tb1`(`uid`,`type`,`target_id`) VALUES(1,1,1);";

$sql2 = "INSERT INTO `tb2`(`uid`,`type`,`target_id`) VALUES(2,2,2);";

$res1 = mysql_query($sql1);

$res2  = mysql_query($sql2);

if($res1 && $res2){

mysql_query('COMMIT');

print('commit success!');

}else{

mysql_query('ROLLBACK');

print('commit failed, rollback!');

}

mysql_query('END');