📄 rzxxqb.php
字号:
<?php
ob_start();
session_start();
//$_SESSION['inf']=0;
include './include/conn.php';
//没页显示记录数
$PageSize = 12;
$StartRow = 0; //开始显示记录的编号
//获取需要显示的页数，由用户提交
if(empty($_GET['PageNo'])){ //如果为空，则表示第1页
if($StartRow == 0){
$PageNo = $StartRow + 1; //设定为1
}
}else{
$PageNo = $_GET['PageNo']; //获得用户提交的页数
$StartRow = ($PageNo - 1) * $PageSize; //获得开始显示的记录编号
}
//因为显示页码的数量是动态变化的
//假如总共有一百页，则不可能同时显示100个链接
//而是根据当前的页数显示一定数量的页面链接
//设置显示页码的初始值
if($PageNo % $PageSize == 0){
$CounterStart = $PageNo - ($PageSize - 1);
}else{
$CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
}
//显示页码的最大值
$CounterEnd = $CounterStart + ($PageSize - 1);
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>主页</title>
</head>
<link rel="stylesheet" href="style.css" type="text/css">
<?php
include './include/conn.php';
$TRecord = mysql_query("select * from file where filetype='认证信息' order by fileid desc");
$result = mysql_query("select * from file where filetype='认证信息' order by fileid desc LIMIT $StartRow,$PageSize");
//获取总记录数
$RecordCount = mysql_num_rows($TRecord);
//获取总页数
$MaxPage = $RecordCount % $PageSize;
if($RecordCount % $PageSize == 0){
$MaxPage = $RecordCount / $PageSize;
}else{
$MaxPage = ceil($RecordCount / $PageSize);
}
?>
<body>
<?php
include './include/head.php';
?>
<div align="center">
<br>
<table width="760" border="1" cellspacing="0" cellpadding="0">
<tr>
<td align="center" class="AttachedFiles">认证信息</td>
</tr>
<tr>
<td height="314" valign="top">
<table width="100%" border="1" class="NormalTableTwo">
<tr>
<td colspan="2" class="AttachedFiles" align="center">
<font size=-1><?php print "总共".$RecordCount."条记录 - 当前页： $PageNo/$MaxPage" ?></font></td>
</tr>
</table>
<table width="100%" border="1" bordercolor="#FFCC99" cellspacing="3" cellpadding="2">
<tr>
<td width="8%" align="center" class="MandatoryFields">编号</td>
<td width="33%" align="center" class="MandatoryFields">标题</td>
<td width="16%" align="center" class="MandatoryFields">类型</td>
<td width="12%" align="center" class="MandatoryFields">发布人</td>
<td width="10%" align="center" class="MandatoryFields">发布时间</td>
</tr>
<?php
$i = 1;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$bil = $i + ($PageNo-1)*$PageSize;
?>
<tr>
<td class="NormalTable" align="center"><?php echo $row[0] ?></td>
<td class="NormalTable" align="center"><a href="fileweb.php?id=<?php echo $row[0];?>" target=_blank><?php echo $row[3] ?></a></td>
<td class="NormalTable" align="center"><?php echo $row[2] ?></td>
<td class="NormalTable" align="center"><?php echo $row[5] ?></td>
<td class="NormalTable" align="center"><?php echo $row[4] ?></td>
</tr>
<?php
$i++;
}?>
</table>
<table width="100%" border="1" bordercolor="#FFCC99" class="AttachedFiles" height="20">
<tr>
<td height="15">
<div align="center">
<?php
echo "<font size=-2>";
//显示第一页或者前一页的链接
//如果当前页不是第1页，则显示第一页和前一页的链接
if($PageNo != 1){
$PrevStart = $PageNo - 1;
print "<a href=rzxxqb.php?PageNo=1>第一页</a>: ";
//print "<a href=fileadmin.php?PageNo=$PrevStart>Previous </a>";
}
print " [ ";
$c = 0;
//打印需要显示的页码
for($c=$CounterStart;$c<=$CounterEnd;$c++){
if($c < $MaxPage){
if($c == $PageNo){
if($c % $PageSize == 0){
print "$c ";
}else{
print "$c ,";
}
}elseif($c % $PageSize == 0){
echo "<a href=rzxxqb.php?PageNo=$c>$c</a> ";
}else{
echo "<a href=rzxxqb.php?PageNo=$c>$c</a> ,";
}//END IF
}else{
if($PageNo == $MaxPage){
print "$c ";
break;
}else{
echo "<a href=rzxxqb.php?PageNo=$c>$c</a> ";
break;
}//END IF
}//END IF
}//NEXT
echo "] ";
if($PageNo < $MaxPage){ //如果当前页不是最后一页，则显示下一页链接
$NextPage = $PageNo + 1;
echo "<a href=rzxxqb.php?PageNo=$NextPage>下一页</a>";
}
//同时如果当前页补上最后一页，要显示最有一页的链接
if($PageNo < $MaxPage){
$LastRec = $RecordCount % $PageSize;
if($LastRec == 0){
$LastStartRecord = $RecordCount - $PageSize;
}
else{
$LastStartRecord = $RecordCount - $LastRec;
}
print " : ";
echo "<a href=rzxxqb.php?PageNo=$MaxPage>最后一页</a>";
}
echo "</font>";
?>
</div> </td>
</tr>
</table> <?php
mysql_free_result($result);
mysql_free_result($TRecord);
?> </td>
</tr>
<tr>
<td height="19" align="right"><a href="index.php">返回主页</a></td>
</tr>
</table>
<br>
</div>
<?php
include './include/end.php';
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -