MySQL transaction processing (one transfer program)

<无详细内容> Header ("Content-type:text/html;charset=utf-8"); $mysqli =new mysqli ("localhost", "root", "" "," Test "); if (Mysqli_connect_errno ()) { printf ("Connection failed:%s ", Mysqli_connect_error ()); Exit (); } $success =true; $price = 8000; $result = $mysqli->query ("Select cash from account where name= ' UserA '"); while ($row = $result->fetch_assoc ()) { $value = $row ["Cash"]; Echo $value; } $mysqli->autocommit (0); if ($value >= $price) { $result = $mysqli->query ("UPDATE account set cash=cash-$price where name= ' UserA '"); }else { echo ' Insufficient balance '; Exit (); } if (! $result or $mysqli->affected_rows!=1) { $success =false; } $result = $mysqli->query ("UPDATE account set cash=cash+ $price where name= ' UserB '"); if (!result or $mysqli->affected_rows!=1) { $success =false; } if ($success) { $mysqli->commit (); Echo ' Transfer succeeded! '; }else { $mysqli->rollback (); echo "Transfer failed!"; } $mysqli->autocommit (1); $query = "Select cash from account where name=?"; $stmt = $mysqli->prepare ($query); $stmt->bind_param (' s ', $name); $name = ' UserA '; $stmt->execute (); $stmt->store_result (); $stmt->bind_result ($cash); while ($stmt->fetch ()) echo "User UserA value is:". $cash; $mysqli->close (); ?> &&&&&&&&&&&&&&&&&& CREATE TABLE account{ UserID smallint unsigned NOT NULL auto_increment, Name varchar () is not NULL, Cash decimal (9,2) is not NULL, Primary KEY (UserID) ) Type=innodb; Insert into account (Name,cash) VALUES (' UserA ', ' 2000 '); Insert into account (Name,cash) VALUES (' UserB ', ' 10000 '); Copy Code

