phpcms如何分页实现末页

<?php
// 数据库连接
$conn = mysqli_connect("localhost", "username", "password", "database");

// 获取总记录数
$total_count = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM table_name"));

// 每页显示的记录数
$per_page = 10;

// 计算总页数
$total_pages = ceil($total_count / $per_page);

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

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

// 获取当前页数据
$sql = "SELECT * FROM table_name LIMIT $start, $per_page";
$result = mysqli_query($conn, $sql);

// 显示数据
while ($row = mysqli_fetch_assoc($result)) {
    echo $row['column_name'] . "<br>";
}

// 生成分页链接
for ($i = 1; $i <= $total_pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}

// 关闭数据库连接
mysqli_close($conn);
?>