老板要数字员工报告，到底交什么才不算空话？ AI

$page = max(1, (int)($_GET["page"] ?? 1));
$size = min(50, max(1, (int)($_GET["size"] ?? 20)));
$off = ($page - 1) * $size;

$sql = "SELECT id, cat, title, created_at FROM posts WHERE deleted=0 ORDER BY id DESC LIMIT :lim OFFSET :off";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(":lim", $size, PDO::PARAM_INT);
$stmt->bindValue(":off", $off, PDO::PARAM_INT);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

header("Content-Type: application/json; charset=utf-8");
echo json_encode(["page"=>$page,"size"=>$size,"items"=>$rows], JSON_UNESCAPED_UNICODE);