首先我介绍一下这个项目的目录结构:
/index.php -- 主入口文件,用于处理数据库、用户登录、注册、结算输赢等所有的操作,使用面向对象式编程,前端后台代码皆于一体
/js/ -- 放置js文件,目前只放了jquery
项目演示地址URL:https://www.niubphp.com/bjl/index1.php
数据库和数据表相关创建语句:或者下载地址:https://www.niubphp.com/bjl/bjl.sql
游戏界面如下:
-- phpMyAdmin SQL Dump
-- version 4.0.10.19
-- https://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2019-11-02 11:31:33
-- 服务器版本: 10.1.21-MariaDB
-- PHP 版本: 5.4.45
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 数据库: `bjl`
--
CREATE DATABASE IF NOT EXISTS `bjl` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `bjl`;
-- --------------------------------------------------------
--
-- 表的结构 `jushu`
--
-- 创建时间: 2019-10-31 09:40:43
--
DROP TABLE IF EXISTS `jushu`;
CREATE TABLE IF NOT EXISTS `jushu` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '桌台号',
`jushu` int(10) NOT NULL COMMENT '进行到的局数',
`youxiao` tinyint(1) NOT NULL COMMENT '是否有效(是否过期)0或1',
`s_time` varchar(255) NOT NULL COMMENT '开盘时间',
`qishu` int(10) NOT NULL COMMENT '总期数',
`j_time` int(10) NOT NULL DEFAULT '30' COMMENT '每局间隔时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- 表的结构 `lists`
--
-- 创建时间: 2019-11-01 06:16:22
--
DROP TABLE IF EXISTS `lists`;
CREATE TABLE IF NOT EXISTS `lists` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`z_id` int(10) NOT NULL COMMENT '对应桌台号',
`jushu` int(10) NOT NULL COMMENT '对应局数',
`sf` tinyint(3) NOT NULL COMMENT '胜负,0闲1庄2和',
`xp` varchar(20) NOT NULL COMMENT '闲牌',
`zp` varchar(20) NOT NULL COMMENT '庄牌',
`xd` tinyint(1) NOT NULL COMMENT '闲点',
`zd` tinyint(1) NOT NULL COMMENT '庄点',
`xb` tinyint(1) NOT NULL COMMENT '闲是否补牌',
`zb` tinyint(1) NOT NULL COMMENT '庄是否补牌',
`kp` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已经开牌',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=665 ;
-- --------------------------------------------------------
--
-- 表的结构 `user`
--
-- 创建时间: 2019-11-01 10:44:42
--
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
`uname` varchar(255) NOT NULL COMMENT '用户名',
`upwd` varchar(255) NOT NULL COMMENT '密码',
`moneys` varchar(255) NOT NULL DEFAULT '10000' COMMENT '余额',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='用户表' AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- 表的结构 `xiazhu`
--
-- 创建时间: 2019-11-01 08:10:07
--
DROP TABLE IF EXISTS `xiazhu`;
CREATE TABLE IF NOT EXISTS `xiazhu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
`uid` int(11) NOT NULL COMMENT '用户ID',
`xiazhu` tinyint(1) NOT NULL COMMENT '下注内容0闲1庄2和',
`zid` int(11) NOT NULL COMMENT '桌台号',
`moneys` varchar(255) NOT NULL COMMENT '下注金额',
`jushu` int(11) NOT NULL COMMENT '对应桌台局数',
`time` varchar(255) NOT NULL COMMENT '下注时间',
`js` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否结算',
`js_time` varchar(255) NOT NULL DEFAULT '--' COMMENT '结算时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
index.php代码如下:或者代码下载地址:https://www.niubphp.com/bjl/index1.php.tmp
<?php
class Game
{
public $z_id; //记录当前操作的桌台号
public $pdo; //保存PDO对象
public $jushu; //保存当前局数
public $qishu; //保存当前桌总期数
public $sheng = ['闲', '庄', '和']; //保存胜者
public $playerInfo; //保存登录玩家信息
public $nextTime; //保存下一局开牌时间
public function __construct()
{
$this->echoHeader();
$this->jushu = $this->haveGame();
$this->jiesuan();
if ($this->jushu === false) {
$this->jushu = 0;
$this->startGame();
}
$this->showInfo();
$this->echoFooter();
}
public function echoFooter() //输出HTML代码尾部
{
echo '</body></html>';
}
public function echoHeader() //输出HTML头部
{
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Document</title>
<style type="text/css">
*{
padding:0px;
margin:0px;
font-size:14px;
}
table{
width:100%;
margin:0px auto;
}
td{
width:14.28%;
padding:10px;
text-align:center;
}
td.z{
color: #4b8bf4;
/* color: #fff; */
font-weight: bold;
}
td.x{
color: #17a05d;
/* color: #fff; */
font-weight: bold;
}
td.h{
color: #dd4f43;
/* color: #fff; */
font-weight: bold;
}
td.s{
color: #f4426d;
}
td.y{
color: #0c3;
}
tr:nth-child(odd){
background: #eef;
}
tr{
background:#fff;
}
tr:hover{
background:#ffe;
}
</style>
</head>
<body>
<?php
}
public function getPlayerInfo() //得到玩家信息
{
$sql = "SELECT `id`,`moneys`,`uname` FROM `user` WHERE `id`='{$_SESSION['id']}'";
$stmt = $this->pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
$this->playerInfo = $result[0];
}
public function showInfo() //显示牌局信息
{
$this->getPlayerInfo();
echo "玩家:<b style='color:red'>{$this->playerInfo['uname']}</b><br>余额:<b style='color:red'>{$this->playerInfo['moneys']}</b><br>";
echo "当前第 {$this->z_id} 桌,已经进行 {$this->jushu} 局,即将";
if ($this->jushu == $this->qishu) {
echo "<a href='./index1.php'>点此换桌洗牌</a><br>";
} else {
$nextTime = date('H:i:s', $this->nextTime);
echo "在 <b>{$nextTime}</b> 开第 " . ($this->jushu + 1) . " 局,倒计时 <b style='color:red'>" . ($this->nextTime - time()) . "</b> 秒,当前桌总局数为 {$this->qishu} 局<br>";
$this->echoContent();
}
$this->getXiazhu();
if ($this->jushu > 0) {
echo "以下为第 {$this->z_id} 桌历史开牌结果";
$this->getHis();
}
}
public function jiesuan() //对下注玩家进行结算
{
$sql = "SELECT max(x.id) as `id`,sum(IF( x.xiazhu = l.sf, IF( x.xiazhu = '1', x.moneys+x.moneys * 0.95, IF( x.xiazhu = '2', x.moneys+x.moneys *8, x.moneys+x.moneys ) ) , if(l.sf='2',x.moneys/2,0)) ) AS 'sy' FROM `xiazhu` AS `x` JOIN `lists` AS `l` ON x.zid = l.z_id AND x.jushu = l.jushu WHERE x.uid='{$_SESSION['id']}' AND x.js='0' AND l.kp='1'";
$stmt = $this->pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
if ($result[0]['id'] != null) {
$id = $result[0]['id'];
$sy = $result[0]['sy'];
$time = date('Y-m-d H:i:s', time());
$sql1 = "UPDATE `user` SET `moneys`=`moneys`+{$sy} WHERE `id`='{$_SESSION['id']}'";
$sql2 = "UPDATE `xiazhu` SET `js`='1',`js_time`='{$time}' WHERE `uid`='{$_SESSION['id']}' AND `id`<='$id' AND `js`='0'";
$this->pdo->beginTransaction();
$this->pdo->exec($sql1);
if ($this->pdo->exec($sql2)) {
$this->pdo->commit();
} else {
$this->pdo->rollBack();
}
}
}
public function getXiazhu() //得到下注记录
{
$sql = "SELECT x.time as `下注时间`,if(x.xiazhu = '0','闲',if(x.xiazhu='1','庄','和')) as '下注内容',if(l.sf = '0','闲',if(l.sf='1','庄','和')) as '开牌',x.moneys as '下注金额',if(x.xiazhu=l.sf,if(x.xiazhu='1',x.moneys*0.95,if(x.xiazhu='2',x.moneys*8,x.moneys)),if(l.sf='2',x.moneys/2*-1,x.moneys*-1)) as '输赢情况',if(x.js=0,'否','已结算') as '是否结算',x.js_time as '结算时间' FROM `xiazhu` as `x` join `lists` as `l` on x.zid = l.z_id and x.jushu = l.jushu WHERE x.uid='{$_SESSION['id']}' AND l.kp='1' order by x.time DESC limit 0,10";
$stmt = $this->pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo '<table cellpadding="5" cellspacing="1" bgcolor="#fff">';
echo '<tr><td>下注时间</td><td>下注内容</td><td>开牌</td><td>下注金额</td><td>输赢情况</td><td>是否结算</td><td>结算时间</td></tr>';
foreach ($result as $v) {
?>
<tr><td><?php echo $v['下注时间']; ?></td><td <?php if ($v['下注内容'] == '庄'): ?>
class='z'
<?php elseif ($v['下注内容'] == '闲'): ?>
<?php endif;?>><?php echo $v['下注内容']; ?></td><td <?php if ($v['开牌'] == '庄'): ?>
class='z'
<?php elseif ($v['开牌'] == '闲'): ?>
<?php endif;?>><?php echo $v['开牌']; ?></td><td><?php echo $v['下注金额']; ?></td><td <?php if ($v['输赢情况'] > 0): ?>
class='y'
<?php endif;?>><?php echo $v['输赢情况']; ?></td><td><?php echo $v['是否结算']; ?></td><td><?php echo $v['结算时间']; ?></td></tr>
<?php
}
echo '</table>';
}
public function echoContent() //输出客户端主要内容
{
?>
<script type="text/javascript" src="./js/jquery.js"></script>
<script type="text/javascript">
nextTime = <?php echo $this->nextTime; ?>;
function daojishi(){
curTime = Date.parse(new Date())/1000;
if(curTime > nextTime+1){
clearInterval(inter);
window.location='./index1.php';
}else if(curTime <= nextTime){
$('.djs').text(nextTime - curTime);
}else{
$('.djs').text('正在开牌..');
}
}
inter = setInterval('daojishi()', 1000);
function msg(str,color){
if(color==undefined){
color='#f00';
}
$('.hidden').html(str).css('color',color).animate({'opacity':'1'},1).delay(2000).animate({'opacity':'0'},1);
}
$(document).ready(function(){
maxmoney = <?php echo $this->playerInfo['moneys']; ?>;//玩家能下注的最大金额(余额)
$('#tz').submit(function(){
xiazhu = $("input[name='xiazhu']:checked").val();
moneys = $("input[name='moneys']").val();
zid = <?php echo $this->z_id; ?>;
jushu = <?php echo $this->jushu + 1; ?>;
if(xiazhu){
if(moneys==''){
msg('请输入下注金额');
$("input[name='moneys']").focus();
}else if(moneys>maxmoney){
msg('余额不足');
}else{
$.ajax({
url:'./index1.php',
type:'post',
data:'xiazhu='+xiazhu+'&moneys='+moneys+'&zid='+zid+'&jushu='+jushu,
dataType:'json',
beforeSend:function( XHR ){
//alert('加载中');
},
complete:function( XHR , textStatus ){
//alert('加载完毕');
},
error:function( XHR , textStatus , errorThrow ){
msg('投注失败!');
},
success:function( data , textStatus ){
if(data.state==0){
msg(data.info);
}else{
$('.yue').html(maxmoney-moneys);
maxmoney-=moneys;
msg(data.info,'#090');
}
}
});
}
}else{
msg('请选择闲庄和');
}
return false;
});
});
</script>
<form action="index1.php" method="post" id="tz">
请选择:
<input type="radio" name="xiazhu" value='0'> <b style='color:red'>闲</b> <b style='color:blue'>赔率:1</b>
<input type="radio" name="xiazhu" value='1'> <b style='color:red'>庄</b> <b style='color:blue'>赔率:0.95</b>
<input type="radio" name="xiazhu" value='2'> <b style='color:red'>和</b> <b style='color:blue'>赔率:8</b>
<input type="text" oninput = "value=value.replace(/[^\d]/g,'')" name="moneys" value="100" style="width:80px;border:1px solid #beface;">元
<input type="button" value="X2" onclick="$('input[name=moneys]').val($('input[name=moneys]').val()*2)">
<input type="button" value="X4" onclick="$('input[name=moneys]').val($('input[name=moneys]').val()*4)">
<input type="button" value="X8" onclick="$('input[name=moneys]').val($('input[name=moneys]').val()*8)">
<input type="button" value="X16" onclick="$('input[name=moneys]').val($('input[name=moneys]').val()*16)">
<input type="button" value="X32" onclick="$('input[name=moneys]').val($('input[name=moneys]').val()*32)">
<input type="submit" value="投注">
<input type="button" value="梭哈" onclick="$('input[name=moneys]').val(maxmoney)">
</form>
<div style='position: absolute;top:150px;left:20%;width:60%;height:100px;background:#fff;font-size:40px;font-weight: blod;text-align: center;line-height: 100px;opacity: 0;'></div>
<?php
}
public function getHis() //得到历史开牌信息
{
$sql = "SELECT * FROM `lists` WHERE `z_id`='{$this->z_id}' AND `jushu`<='{$this->jushu}' ORDER BY `id` DESC;";
$stmt = $this->pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo '<table cellpadding="5" cellspacing="1" bgcolor="#fff">';
echo '<tr><td>局数</td><td>胜者</td><td>闲牌</td><td>庄牌</td><td>闲点</td><td>庄点</td></tr>';
foreach ($result as $v) {
?><tr><td><?php echo $v['jushu']; ?></td><td <?php if ($this->sheng[$v['sf']] == '庄'): ?>
class='z'
<?php elseif ($this->sheng[$v['sf']] == '闲'): ?>
<?php endif;?>><?php echo $this->sheng[$v['sf']]; ?></td><td><?php echo $v['xp']; ?></td><td><?php echo $v['zp']; ?></td><td><?php echo $v['xd']; ?></td><td><?php echo $v['zd']; ?></td></tr>
<?php
}
echo '</table>';
}
public static function connDB() //返回数据库连接
{
$dsn = 'mysql:host=localhost;dbname=bjl;port=3306';
$pdo = new PDO($dsn, 'root', '7f803f4eb7d546c6');
return $pdo;
}
public function startGame() //初始化一局游戏
{
$p = [1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 0, 0, 0];
$p = array_merge($p, $p, $p, $p);
$p = array_merge($p, $p, $p, $p, $p, $p, $p, $p);
shuffle($p);
$r = 0;
$zc = 0;
$xc = 0;
$hc = 0;
$content = '';
$sql_lists = "INSERT INTO `lists`(`z_id`,`jushu`,`sf`,`xp`,`zp`,`xd`,`zd`,`xb`,`zb`) values";
for ($i = 1;; $i++) {
if ($r < count($p) - 6) {
$x = [];
$z = [];
$result = false; //2t,1y,0u
$x[] = $p[$r++];
$z[] = $p[$r++];
$x[] = $p[$r++];
$z[] = $p[$r++];
$xb = $zb = 0;
$xd = array_sum($x) >= 10 ? array_sum($x) % 10 : array_sum($x);
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
if ($xd >= 8 || $zd >= 8) {
if ($xd > $zd) {
$result = 0;
$xc++;
} elseif ($xd < $zd) {
$result = 1;
$zc++;
} else {
$result = 2;
$hc++;
}
} elseif ($xd >= 6) {
if ($zd <= 5) {
$z[] = $p[$r++];
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
$zb = 1;
}
if ($xd > $zd) {
$result = 0;
$xc++;
} elseif ($xd < $zd) {
$result = 1;
$zc++;
} else {
$result = 2;
$hc++;
}
} elseif ($xd <= 5) {
$x[] = $x3 = $p[$r++];
$xd = array_sum($x) >= 10 ? array_sum($x) % 10 : array_sum($x);
$xb = 1;
if ($zd <= 2) {
$z[] = $p[$r++];
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
$zb = 1;
} elseif ($zd == 3) {
if ($x3 != 8) {
$z[] = $p[$r++];
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
$zb = 1;
}
} elseif ($zd == 4) {
if ($x3 >= 2 && $x3 <= 7) {
$z[] = $p[$r++];
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
$zb = 1;
}
} elseif ($zd == 5) {
if ($x3 >= 4 && $x3 <= 7) {
$z[] = $p[$r++];
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
$zb = 1;
}
} elseif ($zd == 6) {
if ($x3 >= 6 && $x3 <= 7) {
$z[] = $p[$r++];
$zd = array_sum($z) >= 10 ? array_sum($z) % 10 : array_sum($z);
$zb = 1;
}
}
if ($xd > $zd) {
$result = 0;
$xc++;
} elseif ($xd < $zd) {
$result = 1;
$zc++;
} else {
$result = 2;
$hc++;
}
}
$xstr = implode(' ', $x);
$zstr = implode(' ', $z);
$content .= "{$i}:{$zstr},{$xstr}\n";
$sql_lists .= "('{$this->z_id}','{$i}','{$result}','{$xstr}','{$zstr}','{$xd}','{$zd}','{$xb}','{$zb}'),";
} else {
$sql_lists = trim($sql_lists, ',');
$this->pdo->exec($sql_lists . ';');
$this->qishu = --$i;
$s_time = date('Y-m-d H:i:s', time());
$this->nextTime = time() + 30;
$sql = "INSERT INTO `jushu`(`jushu`,`youxiao`,`s_time`,`qishu`) VALUES('0','1','{$s_time}','{$i}')";
if (!$this->pdo->exec($sql)) {
$this->startGame();
}
break;
}
}
}
public function haveGame() //用于检查是否存在有效游戏
{
$this->pdo = $this->connDB();
$sql = "SELECT * FROM `jushu` ORDER BY `id` DESC LIMIT 0,1;";
$stmt = $this->pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
$s_time = strtotime($result[0]['s_time']);
if (count($result) == 0 || $result[0]['youxiao'] == 0) {
$this->z_id = 1;
return false;
} elseif ((time() - $result[0]['j_time'] * $result[0]['qishu']) > $s_time + 30) {
$sql = "UPDATE `jushu` SET `youxiao`=0,`jushu`=`qishu` WHERE id<={$result[0]['id']};";
$this->pdo->exec($sql);
$this->z_id = $result[0]['id'] + 1;
return false;
} else {
$this->qishu = $result[0]['qishu'];
$this->z_id = $result[0]['id'];
$qishu = floor((time() - $s_time) / $result[0]['j_time']);
$this->nextTime = $s_time + (($qishu + 1) * $result[0]['j_time']);
$sql = "UPDATE `jushu` SET `youxiao`=1,`jushu`='{$qishu}' WHERE id={$result[0]['id']};UPDATE `lists` SET `kp`='1' WHERE `z_id`='{$this->z_id}' AND `jushu`<='{$qishu}'";
$this->pdo->exec($sql);
return $qishu;
}
}
}
session_start();
if (isset($_SESSION['id']) && !empty($_SESSION['id'])) {
$zid = isset($_POST['zid']) && !empty($_POST['zid']) ? $_POST['zid'] : false;
$xiazhu = (isset($_POST['xiazhu']) && !empty($_POST['xiazhu'])) || $_POST['xiazhu'] == 0 ? $_POST['xiazhu'] : false;
$moneys = isset($_POST['moneys']) && !empty($_POST['moneys']) ? $_POST['moneys'] : false;
$jushu = isset($_POST['jushu']) && !empty($_POST['jushu']) ? $_POST['jushu'] : false;
if ($zid === false || $xiazhu === false || $moneys === false || $jushu === false) {
new Game;
} else {
$info['state'] = 0;
$uid = $_SESSION['id'];
$sql = "SELECT `moneys` FROM `user` WHERE `id`='{$uid}'";
$pdo = Game::connDB();
$stmt = $pdo->query($sql);
$result1 = $stmt->fetchAll(PDO::FETCH_ASSOC);
if ($moneys > $result1[0]['moneys']) {
$info['info'] = '余额不足!';
} else {
$sql = "SELECT `kp` FROM `lists` WHERE `z_id`='{$zid}' AND `jushu`='{$jushu}'";
$stmt = $pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
if ($result[0]['kp'] == 0) {
$m = $result1[0]['moneys'] - $moneys;
$pdo->beginTransaction();
$time = date('Y-m-d H:i:s', time());
$sql1 = "INSERT INTO `xiazhu`(`zid`,`uid`,`xiazhu`,`moneys`,`jushu`,`time`) VALUES('{$zid}','{$uid}','{$xiazhu}','{$moneys}','{$jushu}','{$time}');";
$sql2 = "UPDATE `user` SET `moneys`='{$m}' WHERE `id`='{$uid}';";
if ($pdo->exec($sql1) && $pdo->exec($sql2)) {
$pdo->commit();
$info['state'] = 1;
$info['info'] = '投注成功!';
} else {
$pdo->rollBack();
$info['info'] = '投注失败';
}
} else {
$info['info'] = '投注失败!';
}
}
die(json_encode($info));
}
} else {
$uname = isset($_POST['uname']) && !empty($_POST['uname']) ? $_POST['uname'] : false;
$upwd = isset($_POST['upwd']) && !empty($_POST['upwd']) ? $_POST['upwd'] : false;
if ($uname === false || $upwd === false) {
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<body>
<form action="index1.php" method="post">
用户名:<input type="text" name="uname"><br>
密码:<input type="password" name="upwd" ><br>
<input type="submit" value="登录"><br>
<b style='color:red'>*无帐号也可登录,将为您自动注册</b><br>
<b style='color:red'>*每次登录赠送5000元</b><br>
<b style='color:red'>*首次注册送10个亿</b><br>
</form>
</body>
</html>
<?php
} else {
$sql = "SELECT `id` FROM `user` WHERE `uname`='{$uname}' AND `upwd`='{$upwd}';";
$pdo = Game::connDB();
$stmt = $pdo->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (count($result) == 0) {
$sql = "INSERT INTO `user`(`uname`,`upwd`,`moneys`) VALUES('{$uname}','{$upwd}','1000000000')";
if ($pdo->exec($sql)) {
$_SESSION['id'] = $pdo->lastInsertId();
echo '<script type="text/javascript">alert("注册成功!");window.location="./index1.php";</script>';
} else {
echo '<script type="text/javascript">alert("登录或注册失败!");window.location="./index1.php";</script>';
}
} else {
$sql = "UPDATE `user` SET `moneys`=`moneys`+5000 WHERE `id`='{$result[0]['id']}'";
$pdo->exec($sql);
$_SESSION['id'] = $result[0]['id'];
header('location:./index1.php');
}
}
}
?>
jquery文件下载:https://www.niubphp.com/bjl/js/jquery.js
发表评论
不完善啊