php教程|php手册
PHP,Mysql,事务处理,mysql
php教程-php手册
PHP+Mysql基于事务处理实现转账功能的方法,mysql事务处理
jquery源码注释,vscode vue刷新,rtai ubuntu,批处理tomcat,sqlite3远程访问,织梦新闻推送插件,前端框架有哪些前端开发常用工具,爬虫软件有手机版吗,php display,济源seo优化排名,文章类网站源码,网页脚本源码下载,网站升级中模板lzw
本文实例讲述了PHP+Mysql基于事务处理实现转账功能的方法。分享给大家供大家参考。具体如下:
php影院影城源码,drawio vscode,ubuntu14 dns,keita tomcat,sqlite no in,检查服务器是否被入侵,手机端图片缩放插件,react前端框架排行,java爬虫验证码,php资料下载,张鹏seo,免费开源门户网站系统,仿应用市场网页源码,购物网站模板jsp,html5关闭当前页面,vf学生信息管理系统源代码,c程序源代码下载lzw
<?php header("Content-Type:text/html;charset=utf-8"); $mysqli=new mysqli("localhost","root","","test"); if(mysqli_connect_errno()) { printf("连接失败:%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 余额不足; 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语句如下:
ime输入法源码,ubuntu更换home,tomcat关闭端口的问题,sign防止爬虫,php课程表页面代码,崂山seo优化按天扣费价格lzw
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);