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

Methods and simple examples of paging display of data in PHP

墨辰丷

Release： 2023-03-29 11:56:01

Original

2987 people have browsed it

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:

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>用户列表</title>
</head>
<body>
<?php 
  $con = mysql_connect("localhost","root","");
  
  mysql_query("set names utf8");
  mysql_select_db("zhiye",$con);
  
  $pageSize = 1;   //每页显示的数量
  $rowCount = 0;   //要从数据库中获取
  $pageNow = 1;    //当前显示第几页
  
  //如果有pageNow就使用，没有就默认第一页。
  if (!empty($_GET[&#39;pageNow&#39;])){
    $pageNow = $_GET[&#39;pageNow&#39;];
  }
  
  $pageCount = 0;  //表示共有多少页
  
  $sql1 = "select count(id) from user";
  $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 = "select * from user limit $pre,$pageSize";
  $res2 = mysql_query($sql2);
 
  while($row=mysql_fetch_assoc($res2)){
    echo $row[&#39;user_name&#39;]."<br>";
    echo $row[&#39;name&#39;]."<br>";
    echo $row[&#39;email&#39;]."<br>";
    echo $row[&#39;password&#39;]."<br>";
    echo $row[&#39;tel&#39;]."<br>";
  }
  for ($i=1;$i<=$pageCount;$i++){
    echo "<a href=&#39;userList.php?pageNow=$i&#39;>$i</a> ";
  }
?>
</body>
</html>

Copy after login

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

<?php 
  $con = mysql_connect("localhost","root","");
  
  mysql_query("set names utf8");
  mysql_select_db("zhiye",$con);
  
  $pageSize = 1;   //每页显示的数量
  $rowCount = 0;   //要从数据库中获取
  $pageNow = 1;    //当前显示第几页
  
  //如果有pageNow就使用，没有就默认第一页。
  if (!empty($_GET[&#39;pageNow&#39;])){
    $pageNow = $_GET[&#39;pageNow&#39;];
  }
  
  $pageCount = 0;  //表示共有多少页
  
  $sql1 = "select count(id) from user";
  $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 = "select * from user limit $pre,$pageSize";
  $res2 = mysql_query($sql2);
  
  //$sql = "select * from user";
  //$res = mysql_query($sql,$con);
 
  while($row=mysql_fetch_assoc($res2)){
    echo $row[&#39;user_name&#39;]."<br>";
    echo $row[&#39;name&#39;]."<br>";
    echo $row[&#39;email&#39;]."<br>";
    echo $row[&#39;password&#39;]."<br>";
    echo $row[&#39;tel&#39;]."<br>";
  }
  if($pageNow>1){
    $prePage = $pageNow-1;
    echo "<a href=&#39;userList.php?pageNow=$prePage&#39;>pre</a> ";
  }
  if($pageNow<$pageCount){
    $nextPage = $pageNow+1;
    echo "<a href=&#39;userList.php?pageNow=$nextPage&#39;>next</a> ";
    echo "当前页{$pageNow}/共{$pageCount}页";
  }
  echo "<br/><br/>";
  ?>
 
  <form action="userList.php">
    <input type="text" name="pageNow">
    <input type="submit" value="GO">
  </form>

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!