<?php
//
$conn = mysql_connect('localhost', 'root', '');
mysql_select_db('test', $conn);
mysql_query("SET NAMES GBK");
/*
InnoDB
:
mysql_query('START TRANSACTION');//
mysql_query(' ROLLBACK ');//
mysql_query('COMMIT');//
, , , ,
, ( ), , ,
*/
mysql_query('START TRANSACTION');
$isBad = 0;
$ins_testTable1 = "INSERT INTO testtable1(NAME,age)VALUES('first',23)";
if(!mysql_query($ins_testTable1)){
$isBad =1;
}
//
$ins_testTable2 = "INSERT INTO testtable1(NAME,ages)VALUES('second','24')";
if(!mysql_query($ins_testTable2)){
$isBad =1;
}
if($isBad == 1){
echo $isBad;
mysql_query('ROLLBACK ');
}
mysql_query('COMMIT');
mysql_close($conn);
?>