PHP事務処理メカニズム


<?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);
?>