php如何实现页面分页_php分页功能的实现方法

SELECT COUNT(*)

ceil(总条数 / 每页显示条数)

LIMIT

LIMIT

(当前页码 - 1) * 每页显示条数

(2 - 1) * 10 = 10

href

?page=2

$_GET['page']

<?php
// 1. 配置参数
$itemsPerPage = 10; // 每页显示条数
$currentPage = isset($_GET['page']) ? (int)$_GET['page'] : 1; // 当前页码，默认为1

// 2. 数据库连接（这里为了示例简化，实际项目中请务必使用PDO或MySQLi的预处理语句）
$conn = new mysqli("localhost", "username", "password", "database");
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 3. 获取总记录数
$totalRecordsResult = $conn->query("SELECT COUNT(*) as total FROM your_table");
$totalRecords = $totalRecordsResult->fetch_assoc()['total'];

// 4. 计算总页数
$totalPages = ceil($totalRecords / $itemsPerPage);

// 5. 确保当前页码在有效范围内
if ($currentPage < 1) {
    $currentPage = 1;
} elseif ($currentPage > $totalPages && $totalPages > 0) { // 如果总页数为0，则保持当前页为1
    $currentPage = $totalPages;
} elseif ($totalPages === 0) {
    $currentPage = 1; // 如果没有数据，当前页仍为1
}


// 6. 计算偏移量
$offset = ($currentPage - 1) * $itemsPerPage;

// 7. 获取当前页数据 (注意：生产环境请使用预处理语句防止SQL注入)
$sql = "SELECT * FROM your_table LIMIT $offset, $itemsPerPage";
$result = $conn->query($sql);

echo "<h1>商品列表</h1>";
if ($result && $result->num_rows > 0) {
    echo "<ul>";
    while ($row = $result->fetch_assoc()) {
        echo "<li>" . htmlspecialchars($row['name']) . "</li>"; // 假设有name字段，并进行XSS防护
    }
    echo "</ul>";
} else {
    echo "<p>暂无数据。</p>";
}

// 8. 生成分页链接
echo "<div class='pagination'>";
// 上一页
if ($currentPage > 1) {
    echo "<a href='?page=" . ($currentPage - 1) . "'>上一页</a> ";
}

// 页码链接（简化版，显示当前页前后2页，以及首尾页，带省略号）
$startPage = max(1, $currentPage - 2);
$endPage = min($totalPages, $currentPage + 2);

if ($startPage > 1) {
    echo "<a href='?page=1'>1</a> ";
    if ($startPage > 2) {
        echo "<span>...</span> ";
    }
}

for ($i = $startPage; $i <= $endPage; $i++) {
    if ($i == $currentPage) {
        echo "<span class='current-page'>$i</span> "; // 当前页不加链接，用span突出
    } else {
        echo "<a href='?page=$i'>$i</a> ";
    }
}

if ($endPage < $totalPages) {
    if ($endPage < $totalPages - 1) {
        echo "<span>...</span> ";
    }
    echo "<a href='?page=" . $totalPages . "'>$totalPages</a> ";
}

// 下一页
if ($currentPage < $totalPages) {
    echo "<a href='?page=" . ($currentPage + 1) . "'>下一页</a>";
}
echo "</div>";

$conn->close();
?>

LIMIT

LIMIT offset, count

count

offset

offset

(当前页码 - 1) * 每页显示条数

(3 - 1) * 15 = 30

SELECT * FROM your_table LIMIT 30, 15

SELECT COUNT(*) FROM your_table

COUNT(*)

COUNT(*)

LIMIT

COUNT(*)

1 ... 5 6 [7] 8 9 ... 100

1

...

...

N