PHP mysql transaction: Php/mysql execution Transaction instance

Recent project software upgrades to support transactions, make an example for everyone to learn the reference
Environment MySQL 5.2/php 5
The table type that supports transactions requires InnoDB
<?php
$linkid =mysql_connect (' localhost:3307 ', ' root ', *******);
mysql_select_db (' Web_his ', $linkid);
mysql_query ("Set names UTF8");
/* Create Transaction * *
mysql_query (' Start transaction ') or exit (Mysql_error ());
$ssql 1= "INSERT into pf_item values (' 22 ', ' we ', ' 30 ')"; Execute SQL 1
if (!mysql_query ($ssql 1)) {
echo $ssql 1.mysql_errno (). ":". Mysql_error (). <br> ";
mysql_query (' rollback ') or exit (Mysql_error ());//Determine rollback when execution fails
Exit
}
$ssql 1= "INSERT into pf_item values (', ' hell ', ' 10 ')"; Execute SQL 2
if (!mysql_query ($ssql 1)) {
echo $ssql 1.mysql_errno (). ":". Mysql_error (). <br> ";
mysql_query (' rollback ') or exit (Mysql_error ());//Determine rollback when execution fails
Exit
}
mysql_query (' commit ') or exit (Mysql_error ());//Execute transaction
Mysql_close ($linkid);
?>

This article links http://www.cxybl.com/html/wlbc/Php/20120531/27125.html