PHP SQL分页

<?php
// 获取数据总数
$sql = "SELECT COUNT(*) as total FROM data";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$total = $row['total'];

// 计算总页数
$page_size = 10;
$total_pages = ceil($total / $page_size);

// 获取当前页数
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;

// 使用LIMIT子句查询数据
$start = ($page - 1) * $page_size;
$sql = "SELECT * FROM data LIMIT $start, $page_size";
$result = mysqli_query($conn, $sql);

// 生成分页导航条
$nav = '';
if ($total_pages > 1) {
    $nav .= '<div class="pagination">';
    for ($i = 1; $i <= $total_pages; $i++) {
        if ($i == $page) {
            $nav .= '<span class="current">' . $i . '</span>';
        } else {
            $nav .= '<a href="?page=' . $i . '">' . $i . '</a>';
        }
    }
    $nav .= '</div>';
}

// 输出数据和分页导航条
echo<table>';
while ($row = mysqli_fetch_assoc($result)) {
    echo '<tr><td>' . $row['name'] . '</td><td>' . $row['age'] . '</td></tr>';
}
echo '</table>';
echo $nav;
?>