<?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>