Implement data paging display function based on PHP, PHP implements paging display

Table of Contents

Implement data paging display function based on PHP, PHP realizes paging display

Home

Backend Development

PHP Tutorial

Implement data paging display function based on PHP, PHP implements paging display_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 12, 2016 am 08:50 AM

php Pagination Paginated display

Implement data paging display function based on PHP, PHP realizes paging display

The example in this article shares the PHP implementation code of data paging display function for your reference, the specific content is as follows

Implementation code:

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>用户列表</title>
</head>
<body>
<&#63;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['pageNow'])){
    $pageNow = $_GET['pageNow'];
  }
  
  $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['user_name']."<br>";
    echo $row['name']."<br>";
    echo $row['email']."<br>";
    echo $row['password']."<br>";
    echo $row['tel']."<br>";
  }
  for ($i=1;$i<=$pageCount;$i++){
    echo "<a href='userList.php&#63;pageNow=$i'>$i</a> ";
  }
&#63;>
</body>
</html>

Copy after login

The above is the entire content of this article. I hope it can be a reference for everyone. I also hope that everyone will support Bangke Home.

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