PHP+Mysql基于事务处理实现转账功能的方法

本文实例讲述了PHP+Mysql基于事务处理实现转账功能的方法。分享给大家供大家参考。具体如下：

    <?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='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 '余额不足';
      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 '转账成功!';
      }else
      {
      $mysqli->rollback();
      echo "转账失败!";
      }
      $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 "用户userA的值为：".$cash;
      $mysqli->close();
    ?>

数据库SQL语句如下：

    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');

希望本文所述对大家的php程序设计有所帮助。