<html>
<head><meta http-equiv="Content-type" content="text/html;charset=utf-8">
<style>
body{font-size: 12px;font-family: verdana;width: 100%;}
.page a{border:red 1px solid;text-decoration:none;padding: 2px 5px 2px 5px;margin: 2px;}
.page span.current{border: #000099 1px solid;background-color: #000099;padding: 4px 6px 4px 6px;margin: 2px;color:#ffffff;font-weight: bold;}
.page span.disable{border: #eee 1px solid;padding: 2px 5px 2px 5px;margin: 2px;color:#ddd; }
.page {text-align: center;}
.page form{display: inline;}
.content{height: 280px;}
</style>
</head>
<body>
<?php
header("Content-type=text/html;charset=utf-8");
//1、传入页码
$page = $_GET['p'];
$pagesize=10;
$off=($page-1)*10;
$showPage=5;
//2、根据页码取数据
$host='localhost';
$username='root';
$password='123465';
$db='mallbuilders';
$conn=mysql_connect($host,$username,$password);
if(!$conn){
die("数据库连接失败!");
exit;
}
mysql_select_db("wenzki");
mysql_query("set names utf8");
//编写sql
$sql="SELECT * FROM wenzki order by id asc LIMIT ".$off.",".$pagesize;
$result=mysql_query($sql) or die(mysql_error());
echo "<div class='content'>";
echo "<table border=1 cellspacing=0 width=40% align=center>";
echo "<tr><th>ID</th><th>地址</th></tr>";
while($row=mysql_fetch_assoc($result)){
/*echo $row['id']."<br/>";*/
echo "<tr>";
echo "<td>{$row['id']}</td>";
echo "<td>{$row['user_email']}</td>";
echo "</tr>";
}
echo "</table>";
echo "</div>";
//获取数据总数
$total_sql="select COUNT(*) from wenzki";
$total_res=mysql_query($total_sql) or die(mysql_error());
$res=mysql_fetch_array($total_res);
$total=$res[0];
//计算页数
$total_pages=ceil($total/$pagesize);
/*释放结果集,关闭结果*/
mysql_free_result($result);
mysql_close($conn);
//3、显示数据+分页条
$page_banner="<div class='page'>";
//偏移量
$pageoffset=($showPage-1)/2;
if($page>1){
$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=1'>首页</a>";
$page_banner.="<a href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'><上一页</a>";
}else{
$page_banner.="<span class='disable'>首页</span>";
$page_banner.="<span class='disable'><上一页</span>";
}
//初始化数据
$start=1;
$end=$total_pages;
if ($total_pages>$showPage) {
if ($page>$pageoffset+1) {
$page_banner.="...";
}
if($page>$pageoffset){
$start=$page-$pageoffset;
$end=$total_pages>$page+$pageoffset?$page+$pageoffset:$total_pages;
}else{
$start=1;
$end=$total_pages>$showPage?$showPage:$total_pages;
}
if($page+$pageoffset>$total_pages){
$start=$start-($page+$pageoffset-$end);
}
}
for($i=$start;$i<=$end;$i++){
if($page==$i){
$page_banner.="<span class='current'>{$i}</span>";
}else{
$page_banner.="<a href='".$_SERVER['PHP_SELF']."?p=".$i."'>{$i}</a>";
}
}
//省略尾部
if($total_pages>$showPage&&$total_pages>$page+$pageoffset){
$page_banner.="...";
}
if($page<$total_pages){
$page_banner.="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一页></a>";
$page_banner.="<a href='".$_SERVER['PHP_SELF']."?p=".($total_pages)."'>尾页</a>";
}else{
$page_banner.="<span class='disable'>尾页</span>";
$page_banner.="<span class='disable'>下一页></span>";
}
$page_banner.="共{$total_pages}页";
$page_banner.="<form action='index.php' method='get'>";
$page_banner.="到第<input type='text' size='2' name='p'>页";
$page_banner.="<input type='submit' value='确定'>";
$page_banner.="</form></div>";
echo $page_banner;
?>
</body>
</html>
wenzki
php_go