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;}
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 "
echo "
echo "
ID地址";while($row=mysql_fetch_assoc($result)){
/*echo $row['id']."
";*/
echo "
";echo "
{$row['id']}";echo "
{$row['user_email']}";echo "
";}
echo "
";echo "
//获取数据总数
$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="
//偏移量
$pageoffset=($showPage-1)/2;
if($page>1){
$page_banner="首页";
$page_banner.="";
}else{
$page_banner.="首页";
$page_banner.="";
}
//初始化数据
$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.="{$i}";
}else{
$page_banner.="{$i}";
}
}
//省略尾部
if($total_pages>$showPage&&$total_pages>$page+$pageoffset){
$page_banner.="...";
}
if($page
$page_banner.="下一页>";
$page_banner.="尾页";
}else{
$page_banner.="尾页";
$page_banner.="下一页>";
}
$page_banner.="共{$total_pages}页";
$page_banner.="
";$page_banner.="到第页";
$page_banner.="";
$page_banner.="
echo $page_banner;
?>