Examples of how to use PHP to implement list paging

With the rapid development of the Internet, the number of website visits is also increasing. More and more websites use paging technology to separate content, allowing users to view large amounts of information more conveniently. This article will introduce how to use PHP to implement list paging.

The list paging function divides a series of content into several pages for display. Through the paging function, users can easily view information, reduce web page loading time, and improve user experience.

First of all, to implement list paging in PHP, we need the following steps:

1. Get the content that needs to be paginated

2. Calculate the total number of contents and The total number of pages

3.According to the page number selected by the user, obtain the content of the corresponding page

4.Display the content

We will introduce them one by one below.

1. Get the content that needs to be paginated

Suppose we now have a data table named article, which contains fields such as id, title, and content. We can use database query statements to obtain article records.

//连接数据库
$conn = mysqli_connect("localhost", "root", "123456");
//选取数据库
mysqli_select_db($conn, "test");
//设置字符集
mysqli_query($conn, "SET NAMES UTF8");
//查询数据总数
$sql = "SELECT COUNT(*) FROM article";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_array($result);
$count = $row[0];

2. Calculate the total number of content and total number of pages

After obtaining the total number of data, we need to calculate the total number of pages. Assuming that each page displays 10 records, the total number of pages can be calculated using the following code:

//每页显示的记录数
$pagesize = 10;
//计算总页数
$pagecount = ceil($count/$pagesize);

3. According to the page number selected by the user, obtain the content of the corresponding page

Next, We need to obtain the content of the corresponding page based on the page number selected by the user for display. We can calculate the position of the starting record by getting the page number selected by the user, and then obtain the record of the corresponding page in the database:

$pageno = isset($_GET["pageno"]) ? ($_GET["pageno"]) : 1;
$startno = ($pageno - 1) * $pagesize;
//查询当前页的数据
$sql = "SELECT * FROM article LIMIT ".$startno.",".$pagesize;
$result = mysqli_query($conn, $sql);

4. Display the content

Finally, we need to The obtained content is displayed. Here you can use the foreach statement to traverse each record:

//遍历结果
while($row = mysqli_fetch_array($result)){
    echo "<p>".$row['title']."-".$row['content']."</p>";
}

The complete PHP paging implementation code is as follows:

<?php //连接数据库
$conn = mysqli_connect("localhost", "root", "123456");
//选取数据库
mysqli_select_db($conn, "test");
//设置字符集
mysqli_query($conn, "SET NAMES UTF8");
//查询数据总数
$sql = "SELECT COUNT(*) FROM article";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_array($result);
$count = $row[0];
//每页显示的记录数
$pagesize = 10;
//计算总页数
$pagecount = ceil($count/$pagesize);
//取得当前页码，如果没有则默认为1
$pageno = isset($_GET["pageno"]) ? ($_GET["pageno"]) : 1;
//计算起始位置
$startno = ($pageno - 1) * $pagesize;
//查询当前页的数据
$sql = "SELECT * FROM article LIMIT ".$startno.",".$pagesize;
$result = mysqli_query($conn, $sql);
//遍历结果
while($row = mysqli_fetch_array($result)){
    echo "<p>".$row['title']."-".$row['content']."";
}
//输出分页信息
echo "<p>";
if ($pageno == 1) {
    echo "首页|上一页|";
} else {
    echo "<a>首页</a>|";
    echo "<a>上一页</a>|";
}
if ($pageno == $pagecount) {
    echo "下一页|尾页";
} else {
    echo "<a>下一页</a>|";
    echo "<a>尾页</a>";
}
echo " 当前为第".$pageno."/".$pagecount."页</p>";
//关闭数据库连接
mysqli_close($conn);
?>

The above is the details of how to use PHP to implement list paging. step. Hope this helps!

The above is the detailed content of Examples of how to use PHP to implement list paging. For more information, please follow other related articles on the PHP Chinese website!