PHP MySQL分页查询：如何高效实现精准分页并获取总记录数？

<code class="sql">SELECT * FROM student LIMIT 10, 10;  -- 获取第11-20条记录
SELECT COUNT(*) AS total_count FROM student; -- 获取总记录数</code>

<code class="php"><?php
// 数据库连接信息
$mysqli = new mysqli("localhost", "username", "password", "database");

// 分页参数
$offset = 10; // 起始记录偏移量
$limit = 10;  // 每页显示记录数

// 分页查询SQL语句
$sql1 = "SELECT * FROM student LIMIT ?, ?";
$sql2 = "SELECT COUNT(*) AS total_count FROM student";

// 预处理语句，防止SQL注入
$stmt1 = $mysqli->prepare($sql1);
$stmt1->bind_param("ii", $offset, $limit);
$stmt1->execute();
$result1 = $stmt1->get_result();

$result2 = $mysqli->query($sql2);

// 获取总记录数
$row2 = $result2->fetch_assoc();
$total_count = $row2['total_count'];

// 获取分页数据
$records = [];
while ($row1 = $result1->fetch_assoc()) {
    $records[] = $row1;
}

// 释放结果集
$result1->free_result();
$result2->free_result();
$stmt1->close();

// 输出结果
echo "总记录数：" . $total_count . "<br>";
echo "当前页记录：<br>";
print_r($records); // 使用print_r更清晰地显示数组内容

$mysqli->close();
?></code>