如何通过php get请求实现分页？

<?php
$recordsPerPage = 10;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$startFrom = ($page - 1) * $recordsPerPage;

// 执行数据库查询
$sql = "SELECT * FROM tablename LIMIT $startFrom, $recordsPerPage";
// 执行查询操作...

// 显示查询结果...

// 显示分页导航
$totalRecords = 100; // 总记录数
$totalPages = ceil($totalRecords / $recordsPerPage); // 总页数

// 生成分页导航链接
$pagination = '';
if ($page > 1) {
    $pagination .= '<a href="page.php?page='.($page - 1).'">上一页</a>';
}
for ($i = 1; $i <= $totalPages; $i++) {
    if ($i == $page) {
        $pagination .= '<span>'.$i.'</span>';
    } else {
        $pagination .= '<a href="page.php?page='.$i.'">'.$i.'</a>';
    }
}
if ($page < $totalPages) {
    $pagination .= '<a href="page.php?page='.($page + 1).'">下一页</a>';
}

echo $pagination;
?>