PHP example analyzes the usage skills of mysql transaction processing

This article mainly introduces PHP examples and analyzes the usage skills of mysql transaction processing. Interested friends can refer to it. I hope it will be helpful to everyone.

The example of this article describes the method of PHP Mysql implementing the transfer function based on transaction processing, as follows:

<?php
  header("Content-Type:text/html;charset=utf-8");
  $mysqli=new mysqli("localhost","root","","test");
  if(mysqli_connect_errno())
  {
  printf("连接失败:%s<br>",mysqli_connect_error());
  exit();
  }
  $success=TRUE;
  $price=8000;
  $result=$mysqli->query("select cash from account where name=&#39;userA&#39;");
  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=&#39;userA&#39;");
  }else {
  echo &#39;余额不足&#39;;
  exit();
  }
  if(!$result or $mysqli->affected_rows!=1)
  {
  $success=FALSE;
  }
  $result=$mysqli->query("UPDATE account set cash=cash+$price where name=&#39;userB&#39;");
  if(!result or $mysqli->affected_rows!=1){
  $success=FALSE;
  }
  if($success)
  {
  $mysqli->commit();
  echo &#39;转账成功!&#39;;
  }else
  {
  $mysqli->rollback();
  echo "转账失败!";
  }
  $mysqli->autocommit(1);
  $query="select cash from account where name=?";
  $stmt=$mysqli->prepare($query);
  $stmt->bind_param(&#39;s&#39;,$name);
  $name=&#39;userA&#39;;
  $stmt->execute();
  $stmt->store_result();
  $stmt->bind_result($cash);
  while($stmt->fetch())
  echo "用户userA的值为：".$cash;
  $mysqli->close();
?>

The database SQL statement is as follows:

create table account{
 userID smallint unsigned not null auto_increment,
 name varchar(45) not null,
 cash decimal(9,2) not null,
 primary key(userID)
)type=InnoDB;
insert into account(name,cash) values ('userA','2000');
insert into account(name,cash) values ('userB','10000');

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

Detailed graphic explanation of parameters and data filtering in php

Cache classification database in php Cache

php file upload management system

The above is the detailed content of PHP example analyzes the usage skills of mysql transaction processing. For more information, please follow other related articles on the PHP Chinese website!