3 ways to implement paging function in PHP Page 1/3, paging 3 pages_PHP tutorial

3 ways to implement paging function in PHP Page 1/3, paging 3 pages

Go directly to the code, I hope everyone will read it carefully.

Method 1: Perform sql query in paging. Several functions need to be called. See the script for details:
1.pager.class.php

<&#63;php
  
  class pager {
    public $sql; //SQL查询语句
    public $datanum; //查询所有的数据总记录数
    public $page_size; //每页显示记录的条数
    protected $_errstr;
    protected $_conn;
    protected $_query_id;

    public function query($query)///这个函数有问题，暂时可以不用
    {
    $ret = false;
    if (!empty($query)) {
      if ($this->_conn === false || !is_resource($this->_conn)) {
       warningLog(__METHOD__ . ': query sql with no connection', true);
      return false;
      }
    $this->_query_id = @mysql_query($query, $this->_conn);
    if ($this->_query_id === false) {
    $this->_errstr = @mysql_error();
    $ret = false;
     } else {
    $this->_errstr = 'SUCCESS';
    $ret = $this->_query_id;
      }
    }
     $msg = ($ret === false) &#63; 'false' : strval($ret);
     debugLog(__METHOD__.": [$msg] returned for sql query [$query]");
    return $ret;
    }
function __construct($sql,$page_size) {
      $result = mysql_query($sql);
      $datanum = mysql_num_rows($result);
      $this->sql=$sql;
      $this->datanum=$datanum;
      $this->page_size=$page_size;
    }

    //当前页数
    public function page_id() {
      if($_SERVER['QUERY_STRING'] == ""){
        return 1;
      }elseif(substr_count($_SERVER['QUERY_STRING'],"page_id=") == 0){
        return 1;
      }else{
        return intval(substr($_SERVER['QUERY_STRING'],8));
      }
    }

    //剩余url值
    public function url() {
      if($_SERVER['QUERY_STRING'] == ""){
        return "";
      }elseif(substr_count($_SERVER['QUERY_STRING'],"page_id=") == 0){
        return "&".$_SERVER['QUERY_STRING'];
      }else{
        return str_replace("page_id=".$this->page_id(),"",$_SERVER['QUERY_STRING']);
      }
    }

    //总页数
    public function page_num() {
      if($this->datanum == 0){
        return 1;
      }else{
        return ceil($this->datanum/$this->page_size);
      }
    }
//数据库查询的偏移量
    public function start() {
      return ($this->page_id()-1)*$this->page_size;
    }

    //数据输出
    public function sqlquery() {
      return $this->sql." limit ".$this->start().",".$this->page_size;
    }

    //获取当前文件名
    private function php_self() {
      return $_SERVER['PHP_SELF'];
    }

    //上一页
    private function pre_page() {
      if ($this->page_id() == 1) { //页数等于1
        return "<a href=".$this->php_self()."&#63;page_id=1".$this->url().">上一页</a> ";
      }elseif ($this->page_id() != 1) { //页数不等于1
        return "<a href=".$this->php_self()."&#63;page_id=".($this->page_id()-1).$this->url().">上一页</a> ";
      }
    }

    //显示分页
    private function display_page() {
      $display_page = "";
      if($this->page_num() <= 10){ //小于10页
        for ($i=1;$i<=$this->page_num();$i++) //循环显示出页面
          $display_page .= "<a href=".$this->php_self()."&#63;page_id=".$i.$this->url().">".$i."</a> ";
          return $display_page;
      }elseif($this->page_num() > 10){ //大于10页
        if($this->page_id() <= 6){
          for ($i=1;$i<=10;$i++) //循环显示出页面
            $display_page .= "<a href=".$this->php_self()."&#63;page_id=".$i.$this->url().">".$i."</a> ";
            return $display_page;
        }elseif(($this->page_id() > 6) && ($this->page_num()-$this->page_id() >= 4)){
          for ($i=$this->page_id()-5;$i<=$this->page_id()+4;$i++) //循环显示出页面
            $display_page .= "<a href=".$this->php_self()."&#63;page_id=".$i.$this->url().">".$i."</a> ";
 return $display_page;
        }elseif(($this->page_id() > 6) && ($this->page_num()-$this->page_id() < 4)){
          for ($i=$this->page_num()-9;$i<=$this->page_num();$i++) //循环显示出页面
            $display_page .= "<a href=".$this->php_self()."&#63;page_id=".$i.$this->url().">".$i."</a> ";
            return $display_page;
        }
      }
    }

    //下一页
    private function next_page() {
      if ($this->page_id() < $this->page_num()) { //页数小于总页数
        return "<a href=".$this->php_self()."&#63;page_id=".($this->page_id()+1).$this->url().">下一页</a> ";
      }elseif ($this->page_id() == $this->page_num()) { //页数等于总页数
        return "<a href=".$this->php_self()."&#63;page_id=".$this->page_num().$this->url().">下一页</a> ";
      }
    }

    // 设置分页信息
    public function set_page_info() {
      $page_info = "共".$this->datanum."条 ";
      $page_info .= "<a href=".$this->php_self()."&#63;page_id=1".$this->url().">首页</a> ";
      $page_info .= $this->pre_page();
      $page_info .= $this->display_page();
      $page_info .= $this->next_page();
      $page_info .= "<a href=".$this->php_self()."&#63;page_id=".$this->page_num().$this->url().">尾页</a> ";
      $page_info .= "第".$this->page_id()."/".$this->page_num()."页";
      return $page_info;
    }

  }
&#63;>

2. Script 2:

<&#63;php
  //类的用法
  // 读取分页类
  include("pager.class.php");
  // 数据库连接初始化
//  $db = new mysql();
  $impeach_host = '10.81.43.139';
  $impeach_usr = 'vmtest15';
  $impeach_passwd = 'vmtest15';
  $impeach_name = 'ufeature';
  $impeach_con = mysql_connect($impeach_host, $impeach_usr, $impeach_passwd) or
    die("Can't connect ".mysql_error());
  mysql_select_db($impeach_name, $impeach_con);
  // 这是一个sql查询语句，并得到查询结果
  $sql = "select word from ufeature.spam_accuse_word_list where flag='0'";
  // 分页初始化
  $page = new pager($sql,20);
  // 20是每页显示的数量
  // $res_1 = mysql_query($sql) or
  //    die("Can't get result ".mysql_error());

   $result=mysql_query($page->sqlquery());
while($info = mysql_fetch_array($result,MYSQL_ASSOC)){

  // while($info = mysql_fetch_array($res_1, MYSQL_ASSOC)){
  echo $info["word"]."<br/>";
  }
  // 页码索引条
  echo $page->set_page_info();


&#63;>

Method 2: Using ajax
1. First understand the usage of limit in SQL statements

SELECT * FROM table …… limit 开始位置 ， 操作条数 （其中开始位置是从0开始的）

Example
Get the first 20 records: SELECT * FROM table... limit 0, 20
Get 20 records starting from the 11th one: SELECT * FROM table... limit 10, 20
LIMIT n is equivalent to LIMIT 0,n.
Such as select * from table LIMIT 5; //Return the first 5 rows, is the same as select * from table LIMIT 0, 5
2. Paging principle
The so-called paging display means that the result set in the database is displayed one by one
How to divide it into paragraphs, what paragraph is it currently on (how many items per page, what page is it currently on)
The first 10 records: select * from table limit 0,10
Records 11 to 20: select * from table limit 10,10
Records 21 to 30: select * from table limit 20,10
Paging formula:
(Current page number - 1) X Number of items per page, Number of items per page

Select * from table limit ($Page- 1) * $PageSize, $PageSize 

3. $_SERVER["REQUEST_URI"] function
A type of predefined server variable. All variables starting with $_SERVER are called predefined server variables.
The function of REQUEST_URI is to obtain the current URI, that is, the complete address path behind it except the domain name.
Example:
The current page is: http://www.test.com/home.php?id=23&cid=22
echo $_SERVER["REQUEST_URI"]
The result is:/home.php?id=23&cid=22
4. parse_url() parsing URL function
parse_url() is a function that parses URL into an array with fixed key values ​​
Example

$ua=parse_url("http://username:password@hostname/path?arg=value#anchor");
print_r($ua);

Result:

Array
(
 [scheme] => http  ；协议
 [host] => hostname  ；主机域名
 [user] => username  ；用户
 [pass] => password  ；密码
 [path] => /path   ；路径
 [query] => arg=value  ；取参数
 [fragment] => anchor  ；
)

​

5. Code examples
This page for a message is divided into 3 parts, one is the database design, one is the connection page, and the other is the display page.
(1) Design database
The design database is named bbs, and there is a data table called message, which contains fields such as title, lastdate, user, and content, which respectively represent the message title, the date of the message, the person who left the message, and the content of the message
(2) Connection page

<&#63;php
$conn = @ mysql_connect("localhost", "root", "123456") or die("数据库链接错误");
mysql_select_db("bbs", $conn);
mysql_query("set names 'GBK'"); //使用GBK中文编码;
//将空格，换行转换为HTML可解析
function htmtocode($content) {
 $content = str_replace("\n", "<br>", str_replace(" ", " ", $content)); //两个str_replace嵌套
 return $content;
}
//$content=str_replace("'","‘",$content);
 //htmlspecialchars();
 
&#63;>

(3) Display page

<?php
 include("conn.php");
$pagesize=2; //Set to display 2 records per page
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];

$numq=mysql_query("SELECT * FROM `message`");
$num = mysql_num_rows($numq);
if($_GET
<p align="left"></p><div style="display:none;">
<span id="url" itemprop="url">http://www.bkjia.com/PHPjc/1067830.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http: //www.bkjia.com/PHPjc/1067830.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">3 ways to implement paging function in php Page 1/3, paging 3 pages directly enter the code, I hope everyone will pay attention read. Method 1: To perform paging of SQL queries, you need to call several functions. For details, see...</span>
</div>
<div class="art_confoot"></div>