Php+mysql transaction Rollback&commit Sample _php Tips

mysql_query ("Begin");/Start a transaction
mysql_query ("SET autocommit=0"); Set transaction not automatic commit
$insert = "INSERT INTO UserInfo VALUES (' aa12 ', ' AA ', ' 1 ', ' aaa ')";
mysql_query ($insert);
mysql_query ("commit");//non-autocommit mode, you must manually perform a COMMIT to make the operation effective
mysql_query ("SET autocommit=0");
$insert = "INSERT INTO UserInfo VALUES (' aa20 ', ' AA ', ' 1 ', ' aaa ')";
$insert = "INSERT INTO UserInfo VALUES (' aa8 ', ' AA ', ' 1 ')";
mysql_query ("COMMIT");
if (mysql_num_rows==0)
mysql_query ("ROLLBACK")//non-autocommit mode, performing ROLLBACK to invalidate transaction operations
else echo "OK";
mysql_query ("close");
mysql_query ("SET autocommit=1");//Recovery autocommit mode
$insert = "INSERT INTO UserInfo VALUES (' aa15 ', ' AA ', ' 1 ', ' aaa ')";
mysql_query ($insert);//You do not need to perform a commit manually to make the transaction operational

After the begin is performed, its function is the same as set autocommit=0, and setting autocommit=0 or 1 o'clock is not valid thereafter. Therefore, in order to make the operation clear, generally do not use begin.