uniapp实现买定离手小游戏

<?php include '../api/conn.php'; if (!$_POST) { die( json_encode( array( 'code' => 200, 'msg' => '缺少参数' ),480) ); } $period=$_POST['period']; $openid=$_POST['openid']; $number=$_POST['number']; $price=$_POST['price']; //查询当前提交期数与系统最后期数一致吗（期数一致） $sql1="SELECT period,is_processed FROM game_periods ORDER BY period DESC LIMIT 1"; $result = $conn->query($sql1); if ($result->num_rows > 0) { // 读取查询结果中的一行数据 $row = $result->fetch_assoc(); // 获取id字段的值 $period_database = $row['period']; $is_processed = $row['is_processed']; if ($period_database==$period&&$is_processed=='0') { //防止写入两次 $query_sql="SELECT id FROM `periods_data` WHERE `period`='$period'and `openid`='$openid'"; $result = $conn->query($query_sql); if ($result->num_rows > 0) { die( json_encode( array( 'code' => 200, 'msg' => '已经押注过啦~' ),480) ); } else { // 余额支付 //我的余额查询 $cx_yue="SELECT `price` FROM `user` WHERE `openid`='$openid'"; $res=$conn->query($cx_yue); if ($rowss=$res->fetch_assoc()) { $my_money=$rowss['price'];//我的余额 } else { die( json_encode( array( 'code' => 200, 'msg' => '当前用户未注册' ),480) ); } $buy=$price;//真正需要付的钱 // var_dump($buy); //余额判断 if ($my_money>=$buy) { // 余额扣除 $residue_money=$my_money-$buy; $money_update="UPDATE `user` SET `price` = '$residue_money' WHERE `openid` = '$openid'"; $res2=$conn->query($money_update); //插入操作 $sql2="INSERT INTO `periods_data` (`id`, `period`, `number`, `openid`, `price`) VALUES (NULL, '$period_database', '$number', '$openid', '$price')"; $conn->query($sql2); die( json_encode( array( 'code' => 100, 'msg' => '押注成功' ),480) ); } else { die( json_encode( array( 'code' => 200, 'msg' => '余额不足' ),480) ); } // 余额支付 } } else { die( json_encode( array( 'code' => 200, 'msg' => '该局游戏不存在，请刷新后重试' ),480) ); } } else { die( json_encode( array( 'code' => 200, 'msg' => '游戏暂未开盘' ),480) ); } // 关闭数据库连接 $conn->close(); //放防止重复提交（同个用户一期只能提交一次）