Methods and simple examples of paging display of data in PHP-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Methods and simple examples of paging display of data in PHP

Jun 02, 2018 am 09:55 AM

php method show

This article mainly introduces the method and simple examples of paging data display in PHP. Interested friends can refer to it. I hope it will be helpful to everyone.

Paging is a frequently used function in background management. Paging display facilitates the management of large amounts of data.

The example code is as follows:

&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
  &lt;meta charset=&quot;utf-8&quot;&gt;
  &lt;title&gt;用户列表&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;?php 
  $con = mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;);
  
  mysql_query(&quot;set names utf8&quot;);
  mysql_select_db(&quot;zhiye&quot;,$con);
  
  $pageSize = 1;   //每页显示的数量
  $rowCount = 0;   //要从数据库中获取
  $pageNow = 1;    //当前显示第几页
  
  //如果有pageNow就使用，没有就默认第一页。
  if (!empty($_GET[&#39;pageNow&#39;])){
    $pageNow = $_GET[&#39;pageNow&#39;];
  }
  
  $pageCount = 0;  //表示共有多少页
  
  $sql1 = &quot;select count(id) from user&quot;;
  $res1 = mysql_query($sql1);
  
  if($row1=mysql_fetch_row($res1)){
    $rowCount = $row1[0];
  }
  
  //计算共有多少页，ceil取进1
  $pageCount = ceil(($rowCount/$pageSize));
  
  //使用sql语句时，注意有些变量应取出赋值。
  $pre = ($pageNow-1)*$pageSize;
  
  $sql2 = &quot;select * from user limit $pre,$pageSize&quot;;
  $res2 = mysql_query($sql2);
 
  while($row=mysql_fetch_assoc($res2)){
    echo $row[&#39;user_name&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;name&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;email&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;password&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;tel&#39;].&quot;&lt;br&gt;&quot;;
  }
  for ($i=1;$i&lt;=$pageCount;$i++){
    echo &quot;&lt;a href=&#39;userList.php?pageNow=$i&#39;&gt;$i&lt;/a&gt; &quot;;
  }
?&gt;
&lt;/body&gt;
&lt;/html&gt;

Copy after login

The above method cannot be used when there is a large amount of data.

&lt;?php 
  $con = mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;);
  
  mysql_query(&quot;set names utf8&quot;);
  mysql_select_db(&quot;zhiye&quot;,$con);
  
  $pageSize = 1;   //每页显示的数量
  $rowCount = 0;   //要从数据库中获取
  $pageNow = 1;    //当前显示第几页
  
  //如果有pageNow就使用，没有就默认第一页。
  if (!empty($_GET[&#39;pageNow&#39;])){
    $pageNow = $_GET[&#39;pageNow&#39;];
  }
  
  $pageCount = 0;  //表示共有多少页
  
  $sql1 = &quot;select count(id) from user&quot;;
  $res1 = mysql_query($sql1);
  
  if($row1=mysql_fetch_row($res1)){
    $rowCount = $row1[0];
  }
  
  //计算共有多少页，ceil取进1
  $pageCount = ceil(($rowCount/$pageSize));
  
  //使用sql语句时，注意有些变量应取出赋值。
  $pre = ($pageNow-1)*$pageSize;
  
  $sql2 = &quot;select * from user limit $pre,$pageSize&quot;;
  $res2 = mysql_query($sql2);
  
  //$sql = &quot;select * from user&quot;;
  //$res = mysql_query($sql,$con);
 
  while($row=mysql_fetch_assoc($res2)){
    echo $row[&#39;user_name&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;name&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;email&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;password&#39;].&quot;&lt;br&gt;&quot;;
    echo $row[&#39;tel&#39;].&quot;&lt;br&gt;&quot;;
  }
  if($pageNow&gt;1){
    $prePage = $pageNow-1;
    echo &quot;&lt;a href=&#39;userList.php?pageNow=$prePage&#39;&gt;pre&lt;/a&gt; &quot;;
  }
  if($pageNow&lt;$pageCount){
    $nextPage = $pageNow+1;
    echo &quot;&lt;a href=&#39;userList.php?pageNow=$nextPage&#39;&gt;next&lt;/a&gt; &quot;;
    echo &quot;当前页{$pageNow}/共{$pageCount}页&quot;;
  }
  echo &quot;&lt;br/&gt;&lt;br/&gt;&quot;;
  ?&gt;
 
  &lt;form action=&quot;userList.php&quot;&gt;
    &lt;input type=&quot;text&quot; name=&quot;pageNow&quot;&gt;
    &lt;input type=&quot;submit&quot; value=&quot;GO&quot;&gt;
  &lt;/form&gt;

Copy after login

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

How to implement scheduled execution function based on sleep function in PHP

php Input and output Detailed explanation and example analysis of streams

Detailed explanation of PHP output buffer control

The above is the detailed content of Methods and simple examples of paging display of data in PHP. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

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