php怎么实现无刷新分页效果

2025-01-01 06:29:42
推荐回答(2个)
回答1:

  php+ajax实现无刷新分页实现方法具体如下:
  limit 偏移量,长度;
  limit 0,7; 第一页
  limit 7,7; 第二页
  limit 14,7; 第三页
  每页信息条数:7
  信息总条数:select count(*) from table
  信息总页数:ceil向上取整(总条数/每页条数)
  1、分页类具体使用
    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.=" uri}&page=1\")'>{$this->config["first"]} ";
  //$html.=" uri}&page=1'>{$this->config["first"]} ";
  return $html;
  }
  /*设置上一页*/
  private function prev() {
  $html = "";
  if ($this->page == 1)
  $html.=' '.$this->config["prev"].' ';
  else
  $html.=" uri}&page=" . ($this->page - 1) . "\")'>{$this->config["prev"]} ";
  //$html.=" uri}&page=".($this->page-1)."'>{$this->config["prev"]} ";
  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.=" uri}&page={$page}\")'>{$page} ";
  }
  $linkPage.=" {$this->page} ";
  for ($i = 1; $i <= $inum; $i++) {
  $page = $this->page + $i;
  if ($page <= $this->pageNum)
  $linkPage.=" uri}&page={$page}\")'>{$page} ";
  else
  break;
  }
  return $linkPage;
  }
  /*设置下一页*/
  private function next() {
  $html = "";
  if ($this->page == $this->pageNum)
  $html.=' '.$this->config["next"].' ';
  else
  $html.=" uri}&page=" . ($this->page + 1) . "\")'>{$this->config["next"]} ";
  //$html.=" uri}&page=".($this->page + 1)."'>{$this->config["next"]} ";
  return $html;
  }
  /*设置尾页*/
  private function last() {
  $html = "";
  if ($this->page == $this->pageNum)
  $html.=' '.$this->config["last"].' ';
  else
  $html.=" uri}&page=" . ($this->pageNum) . "\")'>{$this->config["last"]} ";
  //$html.=" uri}&page=.(this->pageNum).'>{$this->config["last"]} ";
  return $html;
  }
  /*设置页面跳转*/
  private function goPage() {
  return
  '
   ';
  }
  //页面列表配置选项
  function fpage($display = array(0, 1, 2, 3, 4, 5, 6, 7, 8)) {
  $html[0] = " 共有{$this->total}{$this->config["header"]} ";
  $html[1] = " 每页显示" . ($this->end() - $this->start() + 1) . "条,本页{$this->start()}-{$this->end()}条 ";
  $html[2] = " {$this->page}/{$this->pageNum}页 ";
  $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;
  }
  }
  2 数据显示
    //链接数据库
  //获得具体信息
  //分页显示
  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;
  echo $css;
  echo "
  


  
  ";
  //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 "";
  echo "";
  echo "";
  echo "";
  echo "";
  echo "";
  echo "";
  }
  echo "";
  echo "
序号名称数量价格时间
".$i++."".$rsta['goods_name']."".$rsta['goods_number']."".$rsta['goods_price']."".date("Y-m-d H:i:s",$rsta['goods_create_time'])."
".$pagelist."
";
  3 ajax无刷新分页实现
  open(‘get','http://网址/index.php?page=2')
  
  
  
  新建网页
  
  
  
  
  
  
  
  

ajax无刷新分页效果


  

  
  
  

回答2:

js+ajex来实现