query("SELECT COUNT(*) AS num FROM data_table WHERE is_copied = 0");
$row = $stmt->fetch_assoc();
$total = $row['num'];
$stmt->close();
// 计算总页数
$totalPages = ceil($total / $perPage);
// 计算跳过的记录数
$skip = ($page - 1) * $perPage;
// 构建查询
$query = "SELECT * FROM data_table WHERE is_copied = 0 ORDER BY $sort $order LIMIT ?, ?";
$stmt = $conn->prepare($query);
// 查询当前页的数据
$stmt->bind_param("ii", $skip, $perPage);
$stmt->execute();
$rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();
?>
查询数据