<?php

class Pagination {

 private $total; //数据表中总记录数
 private $listRows; //每页显示行数
 private $limit; //mysql 数据库的limit
 private $uri; //分页信息前面的uri地址
 private $pageNum; //页数
 private $config = array('header' => "个记录", "prev" => "【上一页】", "next" => "【下一页】", "first" => "【首 页】", "last" => "【尾 页】");
 private $listNum = 8;

 /*
  * $total 当前信息总条数
  * $listRows 每页显示的条数
  * $pa 下面的page
  http://网址/index.php?page=5
  */

 public function __construct($total, $listRows = 10, $pa = "") {
  $this->total = $total;
  $this->listRows = $listRows;
  $this->uri = $this->getUri($pa);
  $this->page = !empty($_GET["page"]) ? $_GET["page"] : 1;//不传入page，则默认显示首页
  $this->pageNum = ceil($this->total / $this->listRows);
  $this->limit = $this->setLimit();
 }

 //设置每页显示的条数
 private function setLimit() {
  return "Limit " . ($this->page - 1) * $this->listRows . ", {$this->listRows}";
 }

 //获得URL地址
 private function getUri($pa) {
  $url = $_SERVER["REQUEST_URI"] . (strpos($_SERVER["REQUEST_URI"], '?') ? '' : "?") . $pa;

  $parse = parse_url($url);



  if (isset($parse["query"])) {
   parse_str($parse['query'], $params);
   unset($params["page"]);
   $url = $parse['path'] . '?' . http_build_query($params);
  }

  return $url;
 }

 //魔术方法，
 public function __get($args) {
  if ($args == "limit")
   return $this->limit;
  else
   return null;
 }

 //页面开始的条数
 private function start() {
  if ($this->total == 0)
   return 0;
  else
   return ($this->page - 1) * $this->listRows + 1;
 }

 //页面结束的条数
 private function end() {
  return min($this->page * $this->listRows, $this->total);
 }

 /*设置首页*/
 private function first() {
  $html = "";
  if ($this->page == 1)
   $html.=''.$this->config["first"].'';
  else
   $html.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page=1\")'>{$this->config["first"]}</a>";
   //$html.="<a href='{$this->uri}&page=1'>{$this->config["first"]}</a>";

  return $html;
 }

 /*设置上一页*/
 private function prev() {
  $html = "";
  if ($this->page == 1)
   $html.=''.$this->config["prev"].'';
  else
   $html.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page=" . ($this->page - 1) . "\")'>{$this->config["prev"]}</a>";
   //$html.="<a href='{$this->uri}&page=".($this->page-1)."'>{$this->config["prev"]}</a>";

  return $html;
 }

 //页码列表【首页】【2】【3】…………【尾页】
 private function pageList() {
  $linkPage = "";

  $inum = floor($this->listNum / 2);

  for ($i = $inum; $i >= 1; $i--) {
   $page = $this->page - $i;

   if ($page < 1)
    continue;

   $linkPage.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page={$page}\")'>{$page}</a>";
  }

  $linkPage.="{$this->page}";


  for ($i = 1; $i <= $inum; $i++) {
   $page = $this->page + $i;
   if ($page <= $this->pageNum)
    $linkPage.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page={$page}\")'>{$page}</a>";
   else
    break;
  }

  return $linkPage;
 }

 /*设置下一页*/ 
 private function next() {
  $html = "";
  if ($this->page == $this->pageNum)
   $html.=''.$this->config["next"].'';
  else
   $html.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page=" . ($this->page + 1) . "\")'>{$this->config["next"]}</a>";
   //$html.="<a href='{$this->uri}&page=".($this->page + 1)."'>{$this->config["next"]}</a>";

  return $html;
 }

 /*设置尾页*/
 private function last() {
  $html = "";
  if ($this->page == $this->pageNum)
   $html.=''.$this->config["last"].'';
  else
   $html.="<a href='javascript:void(0)' onclick='showPage(\"{$this->uri}&page=" . ($this->pageNum) . "\")'>{$this->config["last"]}</a>";
   //$html.="<a href='{$this->uri}&page=.(this->pageNum).'>{$this->config["last"]}</a>";

  return $html;
 }

 /*设置页面跳转*/
 private function goPage() {

  return 
  '<input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>' . $this->pageNum . ')?' . $this->pageNum . ':this.value;showPage(\'' . $this->uri . '&page=\'+page+\'\')}" value="' . $this->page . '" style="width:25px">
  <input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>' . $this->pageNum . ')?' . $this->pageNum . ':this.previousSibling.value;showPage(\'' . $this->uri . '&page=\'+page+\'\')">';
 }

 //页面列表配置选项
 function fpage($display = array(0, 1, 2, 3, 4, 5, 6, 7, 8)) {
  $html[0] = "共有<b>{$this->total}</b>{$this->config["header"]}";
  $html[1] = "每页显示<b>" . ($this->end() - $this->start() + 1) . "</b>条，本页<b>{$this->start()}-{$this->end()}</b>条";
  $html[2] = "<b>{$this->page}/{$this->pageNum}</b>页";

  $html[3] = $this->first();
  $html[4] = $this->prev();
  $html[5] = $this->pageList();
  $html[6] = $this->next();
  $html[7] = $this->last();
  $html[8] = $this->goPage();
  $fpage = '';
  foreach ($display as $index) {
   $fpage.=$html[$index];
  }

  return $fpage;
 }

}

<?php

//链接数据库

//获得具体信息

//分页显示
header("content-type:text/html;charset=utf-8");
$link = mysql_connect('localhost','root','111111');
mysql_select_db('shop', $link);
mysql_query("set names utf8");
$css = <<<eof
<style type="text/css">
 table {border:1px solid black; width:700px; margin:auto; border-collapse:collapse;}
 td {border:1px solid black; }
</style>
eof;
echo $css;

echo "
<table>
 <tr><td>序号</td><td>名称</td><td>数量</td><td>价格</td><td>时间</td></tr>

";

//1 引入分页类
include "./Pagination.php";

//2. 获得信息总条数
$sql = "select * from sw_goods";
$qry = mysql_query($sql);
$total = mysql_num_rows($qry);
$per = 7;

//3. 实例化分页类对象
$page_obj = new Pagination($total,$per);

//4. 拼装sql语句，获得每页信息
//利用page_obj实现limit的灵活设置
//$page_obj -> limit;
$sqla = "select * from sw_goods ".$page_obj->limit;
$qrya = mysql_query($sqla);

//5. 获得页面列表
$pagelist = $page_obj -> fpage(array(3,4,5,6,7,8));

$i=1;
while($rsta = mysql_fetch_assoc($qrya)){
 echo "<tr>";
 echo "<td>".$i++."</td>";
 echo "<td>".$rsta['goods_name']."</td>";
 echo "<td>".$rsta['goods_number']."</td>";
 echo "<td>".$rsta['goods_price']."</td>";
 echo "<td>".date("Y-m-d H:i:s",$rsta['goods_create_time'])."</td>";
 echo "</tr>";
}
echo "<tr><td colspan=5>".$pagelist."</td></tr>";
echo "</table>";

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
 <head>
  <title>新建网页</title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <meta name="description" content="" />
  <meta name="keywords" content="" />

  <script type="text/javascript">
//获得分页信息ajax函数
function showPage(myurl){
 var xhr = new XMLHttpRequest();
 xhr.onreadystatechange = function(){
  if(xhr.readyState==4){
   var rst = document.getElementById("result");
   rst.innerHTML = xhr.responseText;
  }
 }
 xhr.open("get",myurl);
 xhr.send(null);
}
window.onload = function(){
 showPage("./data1.php"); //获得分页信息
 //showPage("./data.php?page=2");
}
  </script>

  <style type="text/css">
  </style>
 </head>


 <body>
  <h2>ajax无刷新分页效果</h2>
  <div id="result"></div>
 </body>
</html>
<script type="text/javascript">
 document.write(new Date()+"<br />");
 document.write(new Date()+"<br />");
 document.write(new Date()+"<br />");
 document.write(new Date()+"<br />");
</script>