pageClass.php
<?php
class Page{
private $total;//总条数
private $size;//每页条数
private $pageCount;//总页数
private $currentPage;//当前页码
private $showPages = 2;//显示的页码,当前页面左右各2,就是5页
private $pageStart;//显示页码的开始
private $pageEnd;//显示页码的结束
public function __construct($total,$size,$currentPage){
$this->total = $total;
$this->size = $size;
$this->pageCount=ceil($total/$size);
$this->currentPage=$currentPage;
$this->pageStart = $this->currentPage-$this->showPages;
$this->pageEnd = $this->currentPage+$this->showPages;
//如果起始页码小于1那么就设定为1
if($this->pageStart<=1){
//难点
$this->pageEnd = $this->pageEnd+(1-$this->pageStart);
$this->pageStart=1;
}
//如果结束页大于总页数,重置结束页=总页数
if($this->pageEnd>=$this->pageCount){
//难点
if($this->pageCount<$this->showPages*2+1){
$this->pageStart=1;
}else{
$this->pageStart=$this->pageStart-($this->pageEnd-$this->pageCount);
}
$this->pageEnd=$this->pageCount;
}
}
public function Pages(){
$str='<div id=page>';
$str.= $this->home();
$str.= $this->lastPage();
$str.= $this->numPage();
$str.= $this->nextPage();
$str.= $this->last();
$str.= $this->countTotal();
$str.='</div>';
return $str;
}
//首页
private function home(){
if($this->currentPage==1){
$str = '<p>首页</p>';
}else{
$str = '<a href=?page=1>首页</a>';
}
return $str;
}
//上一页
private function lastPage(){
if($this->currentPage==1){
$str = '<p>上一页</p>';
}else{
$str = '<a href=?page='.($this->currentPage-1).'>上一页</a>';
}
return $str;
}
//中间的数字页
private function numPage(){
$str='<p class="pageRemark">... </p> ';
for($i=$this->pageStart;$i<=$this->pageEnd;$i++){
if($i==$this->currentPage){
$str.='<a class="cur" href=?page='.$i.'>'.$i.'</a>';
}else{
$str.='<a href=?page='.$i.'>'.$i.'</a>';
}
}
$str.='<p class="pageRemark">...</p> ';
return $str;
}
//下一页
private function nextPage(){
if($this->currentPage==$this->pageCount){
$str = '<p>下一页</p>';
}else{
$str = '<a href=?page='.($this->currentPage+1).'>下一页</a>';
}
return $str;
}
//末页
private function last(){
if($this->currentPage==$this->pageCount){
$str = '<p>末页</p>';
}else{
$str = '<a href=?page='.$this->pageCount.'>末页</a>';
}
return $str;
}
//统计
private function countTotal(){
return '<p class="pageRemark">共<b>13</b>页<b>100</b>条数据</p>';
}
}
调用 page.php
<?php
//引入分页类
require_once 'pageClass.php';
//链接数据库
try{
$db = new PDO('mysql:host=127.0.0.1;dbname=shop;charset=utf8;port=3306','root','root');
}catch(PDOException $e){
echo 'mysql error:'.$e->getMessage();
}
$sql = 'select * from student';
$stmt = $db->prepare($sql);
$stmt->execute();
//获取总条数
$total = $stmt->rowCount();
$size = 5;//每页条数 0,8; 8,8 16,8
//如果不存在第一页,则默认第一页
isset($_GET['page'])?$currentPage = $_GET['page']:$currentPage=1;
$sql.=" limit ".($currentPage-1)*$size.",$size";
$stmt = $db->prepare($sql);
$stmt->execute();
//查询结果集
$res = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<style>
p{margin:0}
#page{height:40px;padding:20px 0px;}
#page a{display:block;float:left;margin-right:10px;padding:2px 12px;height:24px;border:1px #cccccc solid;background:#fff;text-decoration:none;color:#808080;font-size:12px;line-height:24px;}
#page a:hover{color:#077ee3; border:1px #077ee3 solid;}
#page a.cur{border:none;background:#43badb;color:#fff;}
#page p{float:left;padding:2px 12px;font-size:12px;height:24px;line-height:24px;color:#bbb;border:1px #ccc solid;background:#fcfcfc;margin-right:8px;}
#page p.pageRemark{border-style:none;background:none;margin-right:0px;padding:4px 0px;color:#666;}
#page p.pageRemark b{color:red;}
#page p.pageEllipsis{border-style:none;background:none;padding:4px 0px;color:#808080;}
</style>
</head>
<body>
<?php
echo '<table>';
echo '<tr><th>ID</th><th>姓名</th><th>Emai</th><th>手机号</th></tr>';
foreach($res as $k=>$v){
echo '<tr><td>'.$v['id'].'</td><td>'.$v['name'].'</td><td>'.$v['email'].'</td><td>'.$v['mobile'].'</td></tr>';
}
echo '</table>';
$page = new Page($total,$size,$currentPage);
echo $page->Pages();
?>
</body>
</html>