Analysis of PHP paging display methods [with PHP general paging php tips-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Analysis of PHP paging display methods [with PHP general paging php tips

jacklove

Jun 25, 2018 pm 05:20 PM

phpPagination

This article mainly introduces the method of PHP paging display. It analyzes PHP database query and content combined with simple operation skills of HTML paging display in the form of examples. It also comes with a PHP general paging class for your reference. Friends who need it can Refer to the example below

This article describes the method of paging display in PHP. Share it with everyone for your reference, the details are as follows:

<?php
header("content-type:text/html;charset=utf-8");
$currentpage = 1;
if(isset($_GET[&#39;page&#39;]))
  $currentpage = $_GET[&#39;page&#39;];
//连接数据库
$link = mysql_connect("localhost","root","") or die(&#39;连接失败&#39;);
mysql_select_db(&#39;myschool&#39;);
mysql_query(&#39;set names utf8&#39;);
$sql ="SELECT count(*) as &#39;count&#39; from student";//查询记录的sql语句
$result = mysql_query($sql);
$arr = mysql_fetch_array($result);
$count = $arr[&#39;count&#39;];
$pagesize = 3;
$pages = ceil($count/$pagesize);//共多少页
$prepage = $currentpage -1;
if($prepage<=0)
  $prepage=1;
$nextpage = $currentpage+1;
if($nextpage >= $pages){
 $nextpage = $pages;
}
$start =($currentpage-1) * $pagesize;//起始位置
$sql = "SELECT * from student limit $start,$pagesize";
echo $sql;
// $sql = "select * from student";
$result = mysql_query($sql);
?>
<!-- html部分 -->
<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>Document</title>
</head>
<body>
<table border="1">
 <tr>
 <td>学号</td>
 <td>姓名</td>
 <td>性别</td>
 <td>年龄</td>
 </tr>
<?php while($arr=mysql_fetch_array($result)){ ?>
 <td><?php echo $arr[&#39;number&#39;]; ?></td>
 <td><?php echo $arr[&#39;name&#39;]; ?></td>
 <td><?php echo $arr[&#39;sex&#39;]; ?></td>
 <td><?php echo $arr[&#39;age&#39;]; ?></td>
 </tr>
<?php } ?>
 </table>
 <a href="<?php echo $_SERVER[&#39;PHP_SELF&#39;].&#39;?page=&#39;.$prepage; ?>" rel="external nofollow" >上一页</a>  <a href="<?php echo $_SERVER[&#39;PHP_SELF&#39;].&#39;?page=&#39;.$nextpage; ?>" rel="external nofollow" >下一页</a>
</body>
</html>

Note: When there are two types of php and html in a file, php The file must have an end tag

Attachment: PHP general paging class and usage:

Page.class.php file:

<?php
/**
 * 分页类
 *
 * 调用方式：
 * $p=new Page(总条数,显示页数,当前页码,每页显示条数,[链接]);
 * print_r($p->getPages()); //生成一个页码数组（键为页码，值为链接）
 * echo $p->showPages(1);  //生成一个页码样式（可添加自定义样式）
 *
 */
/*
总条数，需要显示的页数，当前页，每页显示的条数，连接
生成一个一维数组，键为页码 值为连接
返回一个生成好样式的页码（并且可以根据自己需要添加样式）
默认样式 共45条记录,每页显示10条,当前第1/4页 [首页] [上页] [1] [2] [3] .. [下页] [尾页]
*/
class Page{
  protected $count;    //总条数
  protected $showPages;  //需要显示的页数
  protected $countPages; //总页数
  protected $currPage;  //当前页
  protected $subPages;  //每页显示条数
  protected $href;    //连接
  protected $page_arr=array();  //保存生成的页码 键页码 值为连接
  /**
   * __construct 构造函数（获取分页所需参数）
   * @param int $count   总条数
   * @param int $showPages 显示页数
   * @param int $currPage 当前页数
   * @param int $subPages 每页显示数量
   * @param string $href  连接（不设置则获取当前URL）
   */
  public function __construct($count,$showPages,$currPage,$subPages,$href=&#39;&#39;){
    $this->count=$count;
    $this->showPages=$showPages;
    $this->currPage=$currPage;
    $this->subPages=$subPages;
    //如果链接没有设置则获取当前连接
    if(empty($href)){
      $this->href=htmlentities($_SERVER[&#39;PHP_SELF&#39;]);
    }else{
      $this->href=$href;
    }
    $this->construct_Pages();
  }
  /**
   * getPages 返回页码数组
   * @return array 一维数组 键为页码 值为链接
   */
  public function getPages(){
    return $this->page_arr;
  }
  /**
   * showPages 返回生成好的页码
   * @param int $style 样式
   * @return string   生成好的页码
   */
  public function showPages($style=1){
    $func=&#39;pageStyle&#39;.$style;
    return $this->$func();
  }
  /**
   * pageStyle1 分页样式（可参照这个添加自定义样式 例如pageStyle2（））
   * 样式 共45条记录,每页显示10条,当前第1/4页 [首页] [上页] [1] [2] [3] .. [下页] [尾页]
   * @return string
   */
  protected function pageStyle1(){
    /* 构造普通模式的分页
    共4523条记录,每页显示10条,当前第1/453页 [首页] [上页] [1] [2] [3] .. [下页] [尾页]
    */
    $pageStr=&#39;共&#39;.$this->count.&#39;条记录，每页显示&#39;.$this->subPages.&#39;条&#39;;
    $pageStr.=&#39;当前第&#39;.$this->currPage.&#39;/&#39;.$this->countPages.&#39;页 &#39;;
    $_GET[&#39;page&#39;] = 1;
    $pageStr.=&#39;<span>[<a href="&#39;.$this->href.&#39;?&#39;.http_build_query($_GET).&#39;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >首页</a>] </span>&#39;;
    //如果当前页不是第一页就显示上页
    if($this->currPage>1){
      $_GET[&#39;page&#39;] = $this->currPage-1;
      $pageStr.=&#39;<span>[<a href="&#39;.$this->href.&#39;?&#39;.http_build_query($_GET).&#39;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >上页</a>] </span>&#39;;
    }
    foreach ($this->page_arr as $k => $v) {
      $_GET[&#39;page&#39;] = $k;
      $pageStr.=&#39;<span>[<a href="&#39;.$v.&#39;" rel="external nofollow" >&#39;.$k.&#39;</a>] </span>&#39;;
    }
    //如果当前页小于总页数就显示下一页
    if($this->currPage<$this->countPages){
      $_GET[&#39;page&#39;] = $this->currPage+1;
      $pageStr.=&#39;<span>[<a href="&#39;.$this->href.&#39;?&#39;.http_build_query($_GET).&#39;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >下页</a>] </span>&#39;;
    }
    $_GET[&#39;page&#39;] = $this->countPages;
    $pageStr.=&#39;<span>[<a href="&#39;.$this->href.&#39;?&#39;.http_build_query($_GET).&#39;" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >尾页</a>] </span>&#39;;
    return $pageStr;
  }
  /**
   * construct_Pages 生成页码数组
   * 键为页码，值为链接
   * $this->page_arr=Array(
   *         [1] => index.php?page=1
   *         [2] => index.php?page=2
   *         [3] => index.php?page=3
   *         ......)
   */
  protected function construct_Pages(){
    //计算总页数
    $this->countPages=ceil($this->count/$this->subPages);
    //根据当前页计算前后页数
    $leftPage_num=floor($this->showPages/2);
    $rightPage_num=$this->showPages-$leftPage_num;
    //左边显示数为当前页减左边该显示的数 例如总显示7页 当前页是5 左边最小为5-3 右边为5+3
    $left=$this->currPage-$leftPage_num;
    $left=max($left,1); //左边最小不能小于1
    $right=$left+$this->showPages-1; //左边加显示页数减1就是右边显示数
    $right=min($right,$this->countPages); //右边最大不能大于总页数
    $left=max($right-$this->showPages+1,1); //确定右边再计算左边，必须二次计算
    for ($i=$left; $i <= $right; $i++) {
      $_GET[&#39;page&#39;] = $i;
      $this->page_arr[$i]=$this->href.&#39;?&#39;.http_build_query($_GET);
    }
  }
}
?>

Usage example demo.php:

<?php
/**
 * demo
 */
header("content-type:text/html;charset=utf8");
include(&#39;Page.class.php&#39;);  //引入类
//$p=new Page(总条数,显示页数,当前页码,每页显示条数,[链接]);
//连接不设置则为当前链接
$page=isset($_GET[&#39;page&#39;]) ? $_GET[&#39;page&#39;] : 1;
$p=new Page(100,4,$page,8);
//生成一个页码数组（键为页码，值为链接）
echo "<pre class="brush:php;toolbar:false">";
print_r($p->getPages());
//样式 共45条记录,每页显示10条,当前第1/4页 [首页] [上页] [1] [2] [3] .. [下页] [尾页]
echo $p->showPages(1);

Articles you may be interested in:

PHP uses PDO abstraction layer to obtain query results. Example php skills

PHP method to compress image size and convert it to jpg format_php skills

PHP Method Example of Remembering Status When Searching_php Tips

The above is the detailed content of Analysis of PHP paging display methods [with PHP general paging php tips. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Dependency Injection in PHP: Avoiding Common PitfallsMay 16, 2025 am 12:17 AM

DependencyInjection(DI)inPHPenhancescodeflexibilityandtestabilitybydecouplingdependencycreationfromusage.ToimplementDIeffectively:1)UseDIcontainersjudiciouslytoavoidover-engineering.2)Avoidconstructoroverloadbylimitingdependenciestothreeorfour.3)Adhe

How to Speed Up Your PHP Website: Performance TuningMay 16, 2025 am 12:12 AM

ToimproveyourPHPwebsite'sperformance,usethesestrategies:1)ImplementopcodecachingwithOPcachetospeedupscriptinterpretation.2)Optimizedatabasequeriesbyselectingonlynecessaryfields.3)UsecachingsystemslikeRedisorMemcachedtoreducedatabaseload.4)Applyasynch

Sending Mass Emails with PHP: Is it Possible?May 16, 2025 am 12:10 AM

Yes,itispossibletosendmassemailswithPHP.1)UselibrarieslikePHPMailerorSwiftMailerforefficientemailsending.2)Implementdelaysbetweenemailstoavoidspamflags.3)Personalizeemailsusingdynamiccontenttoimproveengagement.4)UsequeuesystemslikeRabbitMQorRedisforb

What is the purpose of Dependency Injection in PHP?May 16, 2025 am 12:10 AM

DependencyInjection(DI)inPHPisadesignpatternthatachievesInversionofControl(IoC)byallowingdependenciestobeinjectedintoclasses,enhancingmodularity,testability,andflexibility.DIdecouplesclassesfromspecificimplementations,makingcodemoremanageableandadapt

How to send an email using PHP?May 16, 2025 am 12:03 AM

The best ways to send emails using PHP include: 1. Use PHP's mail() function to basic sending; 2. Use PHPMailer library to send more complex HTML mail; 3. Use transactional mail services such as SendGrid to improve reliability and analysis capabilities. With these methods, you can ensure that emails not only reach the inbox, but also attract recipients.

How to calculate the total number of elements in a PHP multidimensional array?May 15, 2025 pm 09:00 PM

Calculating the total number of elements in a PHP multidimensional array can be done using recursive or iterative methods. 1. The recursive method counts by traversing the array and recursively processing nested arrays. 2. The iterative method uses the stack to simulate recursion to avoid depth problems. 3. The array_walk_recursive function can also be implemented, but it requires manual counting.

What are the characteristics of do-while loops in PHP?May 15, 2025 pm 08:57 PM

In PHP, the characteristic of a do-while loop is to ensure that the loop body is executed at least once, and then decide whether to continue the loop based on the conditions. 1) It executes the loop body before conditional checking, suitable for scenarios where operations need to be performed at least once, such as user input verification and menu systems. 2) However, the syntax of the do-while loop can cause confusion among newbies and may add unnecessary performance overhead.

How to hash strings in PHP?May 15, 2025 pm 08:54 PM

Efficient hashing strings in PHP can use the following methods: 1. Use the md5 function for fast hashing, but is not suitable for password storage. 2. Use the sha256 function to improve security. 3. Use the password_hash function to process passwords to provide the highest security and convenience.

See all articles