hfysite/phpAPi/getDownloads.php

<?php
include('../conn_mysqli.php');
include('../phpMode/rcodeMap.php');

// 目前基于设备管理的下载项
$page = isset($_GET['page']) ? max(1, min(10, intval($_GET['page']))) : 1;
// 设置 $limit 的默认值为20，并限定取值范围在1-100之间
$limit = isset($_GET['limit']) ? max(1, min(100, intval($_GET['limit']))) : 20;
$offset = ($page - 1) * $limit;

header('Content-Type:text/json;charset=utf-8;');
$resObj = array(
  'rcode' => Rcode_OK,
  'data' => "",
  'msg' => 'ok'
);

try {
  set_time_limit(50);
  $conn = createConn();
  $sql = "";
  $stmt = null;
  $sql = 'select * from mysql85931094_db.hfy_download  order by id desc limit ?,?';
  $stmt = mysqli_prepare($conn, $sql);
  mysqli_stmt_bind_param($stmt, "dd", $offset, $limit);
  mysqli_stmt_execute($stmt);
  $res = mysqli_stmt_get_result($stmt);

  while ($row = mysqli_fetch_assoc($res)) {
    $rs[] = $row;
  }
  mysqli_close($conn);
  $resObj['data'] = $rs;
  echo json_encode($resObj);
}catch(Exception $e)
{
//  echo 'Message: ' .$e->getMessage();
  $resObj['rcode'] = Rcode_ServerError;
  $resObj['msg'] = 'server error';
  echo json_encode($resObj);
}