?php
header("content-type:text/html;charset=utf-8");
$currentpage = 1;
if(isset($_GET['page']))
  $currentpage = $_GET['page'];
//連接數(shù)據(jù)庫(kù)
$link = mysql_connect("localhost","root","") or die('連接失敗');
mysql_select_db('myschool');
mysql_query('set names utf8');
$sql ="SELECT count(*) as 'count' from student";//查詢記錄的sql語(yǔ)句
$result = mysql_query($sql);
$arr = mysql_fetch_array($result);
$count = $arr['count'];
$pagesize = 3;
$pages = ceil($count/$pagesize);//共多少頁(yè)
$prepage = $currentpage -1;
if($prepage=0)
  $prepage=1;
$nextpage = $currentpage+1;
if($nextpage >= $pages){
 $nextpage = $pages;
}
$start =($currentpage-1) * $pagesize;//起始位置
$sql = "SELECT * from student limit $start,$pagesize";
echo $sql;
// $sql = "select * from student";
$result = mysql_query($sql);
?>
!-- html部分 -->
!DOCTYPE html>
html lang="en">
head>
 meta charset="UTF-8">
 title>Document/title>
/head>
body>
table border="1">
 tr>
 td>學(xué)號(hào)/td>
 td>姓名/td>
 td>性別/td>
 td>年齡/td>
 /tr>
?php while($arr=mysql_fetch_array($result)){ ?>
 td>?php echo $arr['number']; ?>/td>
 td>?php echo $arr['name']; ?>/td>
 td>?php echo $arr['sex']; ?>/td>
 td>?php echo $arr['age']; ?>/td>
 /tr>
?php } ?>
 /table>
 a href="?php echo $_SERVER['PHP_SELF'].'?page='.$prepage; ?>" rel="external nofollow" >上一頁(yè)/a>nbsp;nbsp;a href="?php echo $_SERVER['PHP_SELF'].'?page='.$nextpage; ?>" rel="external nofollow" >下一頁(yè)/a>
/body>
/html>

?php
/**
 * 分頁(yè)類
 *
 * 調(diào)用方式：
 * $p=new Page(總條數(shù),顯示頁(yè)數(shù),當(dāng)前頁(yè)碼,每頁(yè)顯示條數(shù),[鏈接]);
 * print_r($p->getPages()); //生成一個(gè)頁(yè)碼數(shù)組（鍵為頁(yè)碼，值為鏈接）
 * echo $p->showPages(1);  //生成一個(gè)頁(yè)碼樣式（可添加自定義樣式）
 *
 */
/*
總條數(shù)，需要顯示的頁(yè)數(shù)，當(dāng)前頁(yè)，每頁(yè)顯示的條數(shù)，連接
生成一個(gè)一維數(shù)組，鍵為頁(yè)碼 值為連接
返回一個(gè)生成好樣式的頁(yè)碼（并且可以根據(jù)自己需要添加樣式）
默認(rèn)樣式 共45條記錄,每頁(yè)顯示10條,當(dāng)前第1/4頁(yè) [首頁(yè)] [上頁(yè)] [1] [2] [3] .. [下頁(yè)] [尾頁(yè)]
*/
class Page{
  protected $count;    //總條數(shù)
  protected $showPages;  //需要顯示的頁(yè)數(shù)
  protected $countPages; //總頁(yè)數(shù)
  protected $currPage;  //當(dāng)前頁(yè)
  protected $subPages;  //每頁(yè)顯示條數(shù)
  protected $href;    //連接
  protected $page_arr=array();  //保存生成的頁(yè)碼 鍵頁(yè)碼 值為連接
  /**
   * __construct 構(gòu)造函數(shù)（獲取分頁(yè)所需參數(shù)）
   * @param int $count   總條數(shù)
   * @param int $showPages 顯示頁(yè)數(shù)
   * @param int $currPage 當(dāng)前頁(yè)數(shù)
   * @param int $subPages 每頁(yè)顯示數(shù)量
   * @param string $href  連接（不設(shè)置則獲取當(dāng)前URL）
   */
  public function __construct($count,$showPages,$currPage,$subPages,$href=''){
    $this->count=$count;
    $this->showPages=$showPages;
    $this->currPage=$currPage;
    $this->subPages=$subPages;
    //如果鏈接沒(méi)有設(shè)置則獲取當(dāng)前連接
    if(empty($href)){
      $this->href=htmlentities($_SERVER['PHP_SELF']);
    }else{
      $this->href=$href;
    }
    $this->construct_Pages();
  }
  /**
   * getPages 返回頁(yè)碼數(shù)組
   * @return array 一維數(shù)組 鍵為頁(yè)碼 值為鏈接
   */
  public function getPages(){
    return $this->page_arr;
  }
  /**
   * showPages 返回生成好的頁(yè)碼
   * @param int $style 樣式
   * @return string   生成好的頁(yè)碼
   */
  public function showPages($style=1){
    $func='pageStyle'.$style;
    return $this->$func();
  }
  /**
   * pageStyle1 分頁(yè)樣式（可參照這個(gè)添加自定義樣式 例如pageStyle2（））
   * 樣式 共45條記錄,每頁(yè)顯示10條,當(dāng)前第1/4頁(yè) [首頁(yè)] [上頁(yè)] [1] [2] [3] .. [下頁(yè)] [尾頁(yè)]
   * @return string
   */
  protected function pageStyle1(){
    /* 構(gòu)造普通模式的分頁(yè)
    共4523條記錄,每頁(yè)顯示10條,當(dāng)前第1/453頁(yè) [首頁(yè)] [上頁(yè)] [1] [2] [3] .. [下頁(yè)] [尾頁(yè)]
    */
    $pageStr='共'.$this->count.'條記錄，每頁(yè)顯示'.$this->subPages.'條';
    $pageStr.='當(dāng)前第'.$this->currPage.'/'.$this->countPages.'頁(yè) ';
    $_GET['page'] = 1;
    $pageStr.='span>[a href="'.$this->href.'?'.http_build_query($_GET).'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >首頁(yè)/a>] /span>';
    //如果當(dāng)前頁(yè)不是第一頁(yè)就顯示上頁(yè)
    if($this->currPage>1){
      $_GET['page'] = $this->currPage-1;
      $pageStr.='span>[a href="'.$this->href.'?'.http_build_query($_GET).'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >上頁(yè)/a>] /span>';
    }
    foreach ($this->page_arr as $k => $v) {
      $_GET['page'] = $k;
      $pageStr.='span>[a href="'.$v.'" rel="external nofollow" >'.$k.'/a>] /span>';
    }
    //如果當(dāng)前頁(yè)小于總頁(yè)數(shù)就顯示下一頁(yè)
    if($this->currPage$this->countPages){
      $_GET['page'] = $this->currPage+1;
      $pageStr.='span>[a href="'.$this->href.'?'.http_build_query($_GET).'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >下頁(yè)/a>] /span>';
    }
    $_GET['page'] = $this->countPages;
    $pageStr.='span>[a href="'.$this->href.'?'.http_build_query($_GET).'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >尾頁(yè)/a>] /span>';
    return $pageStr;
  }
  /**
   * construct_Pages 生成頁(yè)碼數(shù)組
   * 鍵為頁(yè)碼，值為鏈接
   * $this->page_arr=Array(
   *         [1] => index.php?page=1
   *         [2] => index.php?page=2
   *         [3] => index.php?page=3
   *         ......)
   */
  protected function construct_Pages(){
    //計(jì)算總頁(yè)數(shù)
    $this->countPages=ceil($this->count/$this->subPages);
    //根據(jù)當(dāng)前頁(yè)計(jì)算前后頁(yè)數(shù)
    $leftPage_num=floor($this->showPages/2);
    $rightPage_num=$this->showPages-$leftPage_num;
    //左邊顯示數(shù)為當(dāng)前頁(yè)減左邊該顯示的數(shù) 例如總顯示7頁(yè) 當(dāng)前頁(yè)是5 左邊最小為5-3 右邊為5+3
    $left=$this->currPage-$leftPage_num;
    $left=max($left,1); //左邊最小不能小于1
    $right=$left+$this->showPages-1; //左邊加顯示頁(yè)數(shù)減1就是右邊顯示數(shù)
    $right=min($right,$this->countPages); //右邊最大不能大于總頁(yè)數(shù)
    $left=max($right-$this->showPages+1,1); //確定右邊再計(jì)算左邊，必須二次計(jì)算
    for ($i=$left; $i = $right; $i++) {
      $_GET['page'] = $i;
      $this->page_arr[$i]=$this->href.'?'.http_build_query($_GET);
    }
  }
}
?>

?php
/**
 * demo
 */
header("content-type:text/html;charset=utf8");
include('Page.class.php');  //引入類
//$p=new Page(總條數(shù),顯示頁(yè)數(shù),當(dāng)前頁(yè)碼,每頁(yè)顯示條數(shù),[鏈接]);
//連接不設(shè)置則為當(dāng)前鏈接
$page=isset($_GET['page']) ? $_GET['page'] : 1;
$p=new Page(100,4,$page,8);
//生成一個(gè)頁(yè)碼數(shù)組（鍵為頁(yè)碼，值為鏈接）
echo "pre>";
print_r($p->getPages());
//樣式 共45條記錄,每頁(yè)顯示10條,當(dāng)前第1/4頁(yè) [首頁(yè)] [上頁(yè)] [1] [2] [3] .. [下頁(yè)] [尾頁(yè)]
echo $p->showPages(1);