Home > Article > Backend Development > How to implement paging display function of data in PHP
How to implement paging display function of data in PHP
- 墨辰丷Original
- 2018-06-02 10:10:062275browse
This article mainly introduces the data paging display function based on PHP in detail. Paging is a frequently used function in background management. Paging display facilitates the management of large amounts of data. Interested friends can refer to it
Implementation code:
<!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['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?pageNow=$i'>$i</a> ";
}
?>
</body>
</html>
Summary: The above is the entire content of this article, I hope it will be helpful to everyone's learning.
Related recommendations:
phpMethods to solve and avoid repeated form submission
PHP Detailed explanation of the implemented statistical data function
Sharing of two methods of converting PHP array encoding gbk and utf8 to and from each other
The above is the detailed content of How to implement paging display function of data in PHP. For more information, please follow other related articles on the PHP Chinese website!