rollback php+mysql transaction rollback&commit example

mysql_query("BEGIN"); //Start a transaction
mysql_query("SET AUTOCOMMIT=0"); //Set the transaction not to commit automatically
$insert="INSERT INTO userinfo VALUES ('aa12','aa','1 ','aaa')";
mysql_query($insert);
mysql_query("COMMIT");//Non-autocommit mode, COMMIT must be executed manually 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");//In non-autocommit mode, executing ROLLBACK invalidates the transaction operation
else echo "ok";
//mysql_query ("CLOSE");
mysql_query("SET AUTOCOMMIT=1");//Restore autocommit mode
$insert="INSERT INTO userinfo VALUES ('aa15','aa','1','aaa')";
mysql_query($insert);//You don’t need to manually execute COMMIT to make the transaction operation take effect.
After executing BEGIN, its effect is the same as set autocommit=0, and it is invalid when set autocommit=0 or 1 is set later. Therefore, to make the operation clear, BEGIN is generally not used.

The above introduces the rollback php+mysql transaction rollback&commit example, including rollback content. I hope it will be helpful to friends who are interested in PHP tutorials.