<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Bank</title>
<link href="styles.css" rel="stylesheet" type="text/css"/>
<link href="base.css" rel="stylesheet" type="text/css"/>
<link href="engine.css" rel="stylesheet" type="text/css"/>
<link href="other.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div class="maincol">
<div class="content">
<div class="dtop">
<div class="dbtm">
<div class="dcont">
<div class="cbox baseform">
<div class="formtitle">
<div class="dleft">
<div class="dright">
<h3 class="dtitle">�璀</h3>
</div>
</div>
</div>
<table class="tableform">
<tr>
<td colspan="2"><b class="c3">色曉�/脊蜴�</b>
</td>
</tr>
<?php
if(!empty($_GET['sort']))
$sort = $_GET['sort'];
else
$sort = '';
if(!empty($_GET['page']))
{
$page = $_GET['page'];
$page = intval($page);
if($page < 1)
$page = 1;
}
else
$page = 1;
$players_page = 3; //柞蝓讒� 彆曉蜻� 順隆溘靦 熱 羲擋璃獵?
$start = ($page - 1) * $players_page;
$db = 'bank';
$dbuser = 'root';
$dbpass = '';
$dbhost = '127.0.0.1';
$checks_num = 0;
$millionare = '';
mysql_connect($dbhost,$dbuser,$dbpass) or die("could not connect");
mysql_select_db($db) or die("could not open database");
$result = mysql_query("SELECT login FROM `checks`");
$players_num = mysql_num_rows($result);
$pages = ceil($players_num / $players_page);
$result = mysql_query("SELECT checks FROM `checks`");
while($row = mysql_fetch_array($result, MYSQL_BOTH))
$checks_num+=$row['checks'];
if($sort == "checks")
$result = mysql_query("SELECT * FROM `checks` WHERE `checks` >= 0 ORDER BY `checks` DESC LIMIT $start, $players_page");
else
$result = mysql_query("SELECT * FROM `checks` WHERE `checks` >= 0 ORDER BY `login` LIMIT $start, $players_page");
while($row = mysql_fetch_array($result, MYSQL_BOTH))
echo '<tr><td>'.$row['login'].'</td><td class="label">'.$row['checks'].'</td></tr>';
$result = mysql_query("SELECT * FROM `checks` WHERE `checks` >= 0 ORDER BY `checks` DESC");
if($row = mysql_fetch_array($result, MYSQL_BOTH))
echo '柵撲� 菔嫁靜� 彆曉�: <b>'.$row['login'].'</b>, � 獗廈 <b>'.$row['checks'].'</b> 雛蜴蝴</br>';
echo '色曉蜻� � 萌 <b>'.$players_num.'</b>, 隄稞� 雛蜴蝴 <b>'.$checks_num.'</b></br>';
if($sort == "checks")
echo'<a href="/bank.php">俠 畫糟閎雕</a> - <a href="/bank.php?sort=checks">^俠 雛蜴番</a>';
else
echo'<a href="/bank.php">^俠 畫糟閎雕</a> - <a href="/bank.php?sort=checks">俠 雛蜴番</a>';
if($players_num > $players_page)
{
$backpage = $page - 1;
$page = $page + 1;
if($sort == "checks")
if(($page - 1) >= $pages)
echo '<tr><td><a href="/bank.php?sort=checks&page='.$backpage.'">拔頑�</a></td><td class="label">丑雒�</td></tr>';
else if($backpage <= 0)
echo '<tr><td>拔頑�</td><td class="label"><a href="/bank.php?sort=checks&page='.$page.'">丑雒�</a></td></tr>';
else
echo '<tr><td><a href="/bank.php?sort=checks&page='.$backpage.'">拔頑�</a></td><td class="label"><a href="/bank.php?sort=checks&page='.$page.'">丑雒�</a></td></tr>';
else
if(($page - 1) >= $pages)
echo '<tr><td><a href="/bank.php?page='.$backpage.'">拔頑�</a></td><td class="label">丑雒�</td></tr>';
else if($backpage <= 0)
echo '<tr><td>拔頑�</td><td class="label"><a href="/bank.php?page='.$page.'">丑雒�</a></td></tr>';
else
echo '<tr><td><a href="/bank.php?page='.$backpage.'">拔頑�</a></td><td class="label"><a href="/bank.php?page='.$page.'">丑雒�</a></td></tr>';
}
?>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
<!-- PHP code by .csF Dev Team -->
</html>
bank.zip_bank php_zip
版权申诉
77 浏览量
2022-09-21
18:15:50
上传
评论
收藏 4KB ZIP 举报
APei
- 粉丝: 63
- 资源: 1万+
最新资源
- 2c60fbb3dt9ad50ed8864298eea1484b.MP4
- 基于yolov8+dlib实现视觉识别的安全驾驶监测系统部署到jetson NX平台源码+模型.zip
- Qt框架+OpenCV+动态爱心+编程教学+520
- 基于opencv+yolov8实现目标追踪及驻留时长统计源码.zip
- 水稻病害基于Yolov8算法优化目标检测识别与AI辅助决策python源码+模型+使用说明.zip
- 海尔618算价表_七海5.20_16.00xlsx(1)(2).xlsx
- WebCrawler.scr
- 【计算机专业毕业设计】大学生就业信息管理系统设计源码.zip
- YOLO 数据集:8种路面缺陷病害检测【包含划分好的数据集、类别class文件、数据可视化脚本】
- JAVA实现Modbus RTU或Modbus TCPIP案例.zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈