简单分页类

最新推荐文章于 2022-10-14 17:53:40 发布

Time，，

最新推荐文章于 2022-10-14 17:53:40 发布

阅读量97

点赞数

分类专栏： php 文章标签： php

本文链接：https://blog.csdn.net/kaka_2014/article/details/84283112

版权

php 专栏收录该内容

48 篇文章 0 订阅

订阅专栏

分页转自网络已测试验证；后续会继续整理出有样式的分页类；
文件test.php


include("pagging.php");
$link = mysql_connect("localhost","user","pwd")or die(mysql_error());
mysql_select_db("dbname")or die(mysql_error());
$sql = "select * from tbname";
$res = pagging::prepare($sql,5);
while($row = mysql_fetch_array($res)){
	print_r($row);echo '<br>';
}
echo pagging::bar();

文件pagging.php


<?php
class pagging {
  public static $count = 0;
  public static $size = 0;
  public static $page = 0;
  static function prepare($sql, $pagesize=10) {
    $page = isset($_GET['page']) ? $_GET['page'] : 1;
    $pageon = ($page - 1) * $pagesize;
    $sql = preg_replace('/select\s/i', '$0SQL_CALC_FOUND_ROWS ', $sql) . " limit $pageon, $pagesize";
    $rs = mysql_query($sql);
    $p = mysql_query('SELECT FOUND_ROWS()');
    list(self::$count) = mysql_fetch_row($p);
    self::$size = $pagesize;
    self::$page = $page;
    return $rs;
  }  

  static function bar($tpl='') {
    if(!$tpl) $tpl = '<a href=?reset>首页</a> <a href=?prve>上一页</a> <a href=?next>下一页</a> <a href=?end>尾页</a>';
    $count = ceil(self::$count / self::$size);
    $page = self::$page;
    unset($_GET['page']);
    $d = array(
      'reset' => 1,
      'prve' => $page > 1 ? $page - 1 : 1,
      'next' => $page < $count ? $page + 1 : $count,
      'end' => $count,
    );
    foreach($d as $k=>$v) {
      $_GET['page'] = $v;
      $tpl = str_replace($k, http_build_query($_GET), $tpl);
    }
    echo $tpl;
  }
}
?>

通常你都有类似这样的语句 $sql ="....."; $rs = mysql_query($sql); 或 $rs = mysql_query("select ...."); 你只需改作 include 'paging.php'; $rs = paging::prepare($sql, 每页行数); 在需要出现分页条的地方写入 paging::bar(); 就可以了，非常简单！