PHP数据分页实现方法详解

$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$page = max(1, $page); // 防止页码小于1
$limit = 10;
$offset = ($page - 1) * $limit;
$sql = "SELECT id, title, created_at FROM articles ORDER BY id DESC LIMIT ? OFFSET ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$limit, $offset]);
$articles = $stmt->fetchAll();

$totalSql = "SELECT COUNT(*) FROM articles";
$totalStmt = $pdo->query($totalSql);
$totalCount = $totalStmt->fetchColumn();
$totalPages = ceil($totalCount / $limit);

echo "<div class='pagination'>";
if ($page > 1) {
echo "<a href='?page=".($page - 1)."'>上一页</a>";
}
for ($i = 1; $i <= $totalPages; $i++) {
if ($i == $page) {
echo "<strong>[$i]</strong>"; // 当前页高亮
} else {
echo "<a href='?page=$i'>$i</a>";
}
}
if ($page < $totalPages) {
echo "<a href='?page=".($page + 1)."'>下一页</a>";
}
echo "</div>";

// 连接数据库
$pdo = new PDO("mysql:host=localhost;dbname=test", "user", "pass");
// 分页参数
$page = $_GET['page'] ?? 1;
$page = (int)$page;
$limit = 10;
$offset = ($page - 1) * $limit;
// 查询当前页数据
$stmt = $pdo->prepare("SELECT id, title, content FROM articles ORDER BY id DESC LIMIT ? OFFSET ?");
$stmt->execute([$limit, $offset]);
$articles = $stmt->fetchAll();
// 获取总数和总页数
$totalCount = $pdo->query("SELECT COUNT(*) FROM articles")->fetchColumn();
$totalPages = ceil($totalCount / $limit);
// 显示文章列表
foreach ($articles as $article) {
echo "<h3>{$article['title']}</h3>";
}
// 输出分页导航
include 'pagination.php'; // 或直接嵌入上面的分页HTML代码