PHP mysqli學習（六）事物

標籤：

autocommit(0) 關閉事務自動認可

commit() 提交

rollback() 復原

 

<?phpheader(‘content-type:text/html;charset=utf-8‘);$mysqli = @new mysqli(‘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 + 100 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 ‘轉賬成功<br/>‘;    $mysqli->autocommit(TRUE);}else{    $mysqli->rollback();    echo ‘轉賬失敗<br/>‘;}$mysqli->close();

 

PHP mysqli學習（六）事物