怎么用php翻页_php实现数据分页功能的完整代码

<?php

// 数据库配置
$host = 'localhost';
$username = 'your_username';
$password = 'your_password';
$database = 'your_database';
$perPage = 10; // 每页显示的数量

// 连接数据库
$conn = new mysqli($host, $username, $password, $database);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

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

// 计算总页数
$totalPages = ceil($totalRecords / $perPage);

// 获取当前页码
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$page = max(1, min($page, $totalPages)); // 确保页码在有效范围内

// 计算起始位置
$start = ($page - 1) * $perPage;

// 查询当前页的数据
$sql = "SELECT * FROM your_table LIMIT $start, $perPage";
$result = $conn->query($sql);

// 输出数据
if ($result->num_rows > 0) {
    echo "<table>";
    while($row = $result->fetch_assoc()) {
        echo "<tr>";
        foreach ($row as $key => $value) {
            echo "<td>" . htmlspecialchars($value) . "</td>";
        }
        echo "</tr>";
    }
    echo "</table>";
} else {
    echo "没有数据";
}

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

for ($i = 1; $i <= $totalPages; $i++) {
    if ($i == $page) {
        echo "<span>" . $i . "</span> ";
    } else {
        echo "<a href='?page=" . $i . "'>" . $i . "</a> ";
    }
}

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

$conn->close();

?>

SELECT t1.*
FROM your_table t1
INNER JOIN (
    SELECT id
    FROM your_table
    ORDER BY id
    LIMIT $start, $perPage
) t2 ON t1.id = t2.id;

<link rel="prev" href="example.com/products?page=1">
<link rel="next" href="example.com/products?page=3">

<link rel="canonical" href="example.com/products">

$stmt = $conn->prepare("SELECT * FROM your_table LIMIT ?, ?");
$stmt->bind_param("ii", $start, $perPage); // "ii" 表示两个整数
$stmt->execute();
$result = $stmt->get_result();

$page = isset($_GET['page']) ? filter_var($_GET['page'], FILTER_VALIDATE_INT, array("options" => array("min_range"=>1))) : 1;

if ($page === false || $page === null) {
    $page = 1; // 默认值
}