当前位置：首页 > PHP

php实现论坛分页

2026-02-16 04:14:30PHP

实现论坛分页的基本思路

分页功能通常需要结合数据库查询和前端展示。PHP实现论坛分页主要涉及计算总记录数、确定每页显示数量、计算总页数、获取当前页码以及LIMIT子句的使用。

数据库查询准备

假设论坛帖子存储在posts表中，需要先获取总记录数：

$sql = "SELECT COUNT(*) as total FROM posts";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$totalRecords = $row['total'];

设置分页参数

定义每页显示的记录数和计算总页数：

$recordsPerPage = 10;
$totalPages = ceil($totalRecords / $recordsPerPage);

获取当前页码

通过GET参数获取当前页码，并确保其在有效范围内：

$currentPage = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$currentPage = max(1, min($currentPage, $totalPages));

构建分页查询

使用LIMIT子句获取当前页的数据：

$offset = ($currentPage - 1) * $recordsPerPage;
$sql = "SELECT * FROM posts ORDER BY created_at DESC LIMIT $offset, $recordsPerPage";
$result = $conn->query($sql);

显示分页导航

在前端生成分页链接：

echo '<div class="pagination">';
for ($i = 1; $i <= $totalPages; $i++) {
    $active = ($i == $currentPage) ? 'active' : '';
    echo "<a href='?page=$i' class='$active'>$i</a>";
}
echo '</div>';

完整示例代码

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "forum_db");

// 获取总记录数
$sql = "SELECT COUNT(*) as total FROM posts";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$totalRecords = $row['total'];

// 分页设置
$recordsPerPage = 10;
$totalPages = ceil($totalRecords / $recordsPerPage);
$currentPage = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$currentPage = max(1, min($currentPage, $totalPages));

// 获取当前页数据
$offset = ($currentPage - 1) * $recordsPerPage;
$sql = "SELECT * FROM posts ORDER BY created_at DESC LIMIT $offset, $recordsPerPage";
$result = $conn->query($sql);

// 显示帖子列表
while ($row = $result->fetch_assoc()) {
    echo "<div class='post'>";
    echo "<h3>" . htmlspecialchars($row['title']) . "</h3>";
    echo "<p>" . htmlspecialchars($row['content']) . "</p>";
    echo "</div>";
}

// 显示分页导航
echo '<div class="pagination">';
for ($i = 1; $i <= $totalPages; $i++) {
    $active = ($i == $currentPage) ? 'active' : '';
    echo "<a href='?page=$i' class='$active'>$i</a>";
}
echo '</div>';

// 关闭连接
$conn->close();