Cú pháp transaction (php&mysql)

Điều kiện sử dụng: - Table: ENGINE=InnoDB - PHP: Có thư viện MySQLi

<? 
$db=MySQL_connect("localhost", "root", "") or die(MySQL_error()); 
MySQL_select_db("test", $db) or die(MySQL_error());
MySQL_query(" CREATE TABLE `abc` ( 
 `id` int(11) NOT NULL, 
 PRIMARY KEY (`id`) 
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 
 "); 

$all_query_ok=true; 
MySQL_query("START TRANSACTION");
MySQL_query("INSERT INTO abc (id) VALUES (100)") ? null : $all_query_ok=false; 
MySQL_query("INSERT INTO abc (id) VALUES (200)") ? null : $all_query_ok=false; 
MySQL_query("INSERT INTO abc (id) VALUES (300)") ? null : $all_query_ok=false; 
MySQL_query("INSERT INTO abc (id) VALUES (100)") ? null : $all_query_ok=false;
if($all_query_ok){ 
 MySQL_query("COMIT"); 
}else{ 
 MySQL_query("ROLLBACK"); 
} 
MySQL_close($db); 
?>