Autocommit (0) Close transaction autocommit
Commit () Commit
Rollback () rollback
<?PHPHeader(' Content-type:text/html;charset=utf-8 ');$mysqli= @NewMysqli (' localhost:3306 ', ' root ', ' root ', ' Zhy ');if($mysqli-Connect_errno) { die(' Mysqli Connect error: '.$mysqli-connect_error);}$mysqli->set_charset (' UTF8 ');$mysqli->autocommit (FALSE);$sql _add= ' Update account Set money = Money + ' WHERE username = ' User1 ';$sql _reduce= ' Update account set money = money-100 WHERE username = ' User2 ';$res _add=$mysqli->query ($sql _add);$rows _add=$mysqli-affected_rows;$res _reduce=$mysqli->query ($sql _reduce);$rows _reduce=$mysqli-affected_rows;if($res _add&&$res _reduce&&$rows _add>0 &&$rows _reduce>0){ $mysqli-commit (); Echo' Transfer success <br/> '; $mysqli->autocommit (TRUE);}Else{ $mysqli-rollback (); Echo' Transfer failure <br/> ';}$mysqli->close ();
PHP mysqli Learning (vi) Things