用php写一段基于query+access数据库的分页的代码。

以下是基于query()+access数据库的分页代码示例：

query($sql); $total_records = $result->fetchColumn(); //计算总页数 $total_pages = ceil($total_records / $records_per_page); //计算本页的起始记录 $offset = ($page - 1) * $records_per_page; //查询本页要显示的数据 $sql = "SELECT * FROM your_table LIMIT $offset, $records_per_page"; $result = $conn->query($sql); //输出本页数据 echo ""; while ($row = $result->fetch(PDO::FETCH_ASSOC)) { echo ""; echo ""; echo ""; echo ""; //其他字段以此类推 echo ""; } echo "

" . $row['column1'] . "

" . $row['column2'] . "

" . $row['column3'] . "

"; //输出分页链接 echo ""; //关闭数据库连接 $conn = null; ?>