php数据分页加数据显示效果
<?php
include_once (dirname(__FILE__) . '../../Inc/Conn.php');
include_once (dirname(__FILE__) . '../../photo/Inc/function.php');
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
height:17px;
padding:8px 0px 0px 0px;
text-align:center;
}
body {
margin-left: 0px;
margin-top: 10px;
margin-right: 0px;
margin-bottom: 0px;
}
td{
border:1px solid #333;
}
-->
</style></head>
<body>
<div style="height:26px;text-align:left; width:98%;font-size:16px; font-weight:bold; margin:0px auto;">
<a href="export.php" target="_blank">导出Execel表格</a></div>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="8%"><strong>帐号</strong></td>
<td width="14%"><strong>邮箱</strong></td>
<td width="5%"><strong>性别</strong></td>
<td width="9%"><strong>宝宝出生日期</strong></td>
<td width="12%"><strong>省份</strong></td>
<td width="9%"><strong>真实姓名</strong></td>
<td width="12%"><strong>邮编</strong></td>
<td width="10%"><strong>手机</strong></td>
<td width="21%"><strong>地址</strong></td>
</tr>
<?php
$sql = "Select * from tablename";
$result = mysql_query($sql) or die('fail1' . mysql_error());
$rs = mysql_fetch_array($result);
$rdcount = mysql_num_rows($result);
if ($rdcount) {
$pagesize = 20;
$pagecount = ($rdcount % $pagesize) ? (int)($rdcount / $pagesize) + 1 : $rdcount / $pagesize; //统计总页面
$page = isset($_GET['page']) ? $_GET['page'] : 1; //取得当前页面
$start = ($page >= 1 && $page <= $pagecount) ? $start = $pagesize * ($page - 1) : $start = 1; //取得超始记录
$start = $start;
$sql = $sql . " order by add_date desc limit $start,$pagesize";
$result = mysql_query($sql) or die(mysql_error());
while ($rs = mysql_fetch_array($result)) {
echo "<tr>
<td>" . $rs['User_Name'] . "</td>
<td>" . $rs['User_Mail'] . "</td>
<td>" . $rs['User_Baby_Sex'] . "</td>
<td>" . $rs['User_Baby_Birth'] . " </td>
<td>" . $rs['sheng'] . " </td>
<td>" . $rs['User_rname'] . " </td>
<td>" . $rs['User_Zip'] . " </td>
<td>" . $rs['User_Hand'] . " </td>
<td>" . $rs['User_Address'] . " </td>
</tr>
";
}
echo "<tr> <td colspan=9>";
pagelist1($page, $pagecount, $rdcount, '?page=', $pagesize);
echo "</td> </tr> ";
} else {
echo '暂时没有信息!';
}
function pagelist1($page, $pagecount, $totalrecord, $url, $pagesize) {
if ($page == "" || $page > $pagecount) {
$page = 1;
}
echo ("记录" . $totalrecord . "条 每页" . $pagesize . "条 共" . $pagecount . "页 <a href=" . $url . "1> <<</a> ");
if ($page > 1) {
echo ("<a href=" . $url . ($page - 1) . "> < </a> ");
}
if ($page + 9 > $pagecount) {
$current = $pagecount;
} else {
$current = $page + 9;
}
for ($i = $page; $i <= $current; $i++) {
echo ("<a href=" . $url . "$i class='sf'>$i</a> ");
}
if ($pagecount > $page) {
echo ("<a href=" . $url . ($page + 1) . "> > </a> ");
}
echo ("<a href=" . $url . $pagecount . "> >></a> ");
}
?>
</table>
</body>
</html>本文地址：http://www.phprm.com/code/1d4de1c954622fa532d2ebb80b4aa512.html
转载随意，但请附上文章地址:-)