php+mysqli example of transaction transfer with transactions

In this paper, we describe the method of Php+mysqli using transaction processing transfer problem. Share to everyone for reference

<?PHP/**php+mysqli Using Transaction Transfer Problem Example * Author http://www.lai18.com * Date 2015-04-19 * Version 1 **/  Header("content-type:text/html; Charset=utf-8 "); $mysqli=NewMysqli ("localhost", "root", "064319", "PHP"); $mysqli->set_charset ("UTF8"); if($mysqli-Connect_errno) {     die(' Database connection failed '.$mysqli-connect_error); }      $mysqli->autocommit (false);//Auto-commit mode set to False$flag=true;//flag of whether the transaction was executed successfully     $query= "Update account set balance=balance-1000 where id=3"; $result=$mysqli->query ($query); $affected _count=$mysqli-affected_rows; if(!result | |$affected _count= = 0) {//failed$flag=false; }      $query= "Update account set balance=balance+1000 where id=2"; $result=$mysqli->query ($query); $affected _count=$mysqli-affected_rows; if(!$result||$affected _count= = 0) {    $flag=false; }      if($flag) {    $mysqli-commit (); Echo' Successful transfer '; } Else {    $mysqli-rollback (); Echo' Transfer failed '; }      $mysqli->autocommit (true);//Reset transaction to Auto commit$mysqli-close ();?>

Reference Source:
php+mysqli example of transaction transfer with transactions
Http://www.lai18.com/content/368652.html

php+mysqli example of transaction transfer with transactions