hfysite/phpAPi/searchSolution.php

<?php
include('../conn_mysqli.php');
include('../phpMode/rcodeMap.php');
$key = $_POST['key'];
$type = $_POST['type'] ? $_POST['type'] : 'all';
// 设置 $page 的默认值为1，并限定取值范围在1-10之间
$page = isset($_POST['page']) ? max(1, min(10, intval($_POST['page']))) : 1;
// 设置 $limit 的默认值为20，并限定取值范围在1-100之间
$limit = isset($_POST['limit']) ? max(1, min(100, intval($_POST['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;
  if ($type == "all") {
    // 无条件全选
    if (!empty($key)) {
//      echo " \n php is low \n";
      $sql = 'SELECT news.id,news.remark,news.title as name,news.image,news.source,news.sourceType,n_type.type_key
FROM mysql85931094_db.hfy_news as news  , mysql85931094_db.hfy_news_type as n_type
where news.type_id = n_type.type_id and news.title like \''.$key.'\' order by news.id desc limit ?,?';
    } else {
//      echo " \n fuck php  \n";
      $sql = 'SELECT news.id,news.remark,news.title as name,news.image,news.source,news.sourceType,n_type.type_key
FROM mysql85931094_db.hfy_news as news , mysql85931094_db.hfy_news_type as n_type
where news.type_id = n_type.type_id order by news.id desc  limit ?,?';

    }
    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param($stmt, "dd", $offset, $limit);
  } else {
    if (!empty($key)) {
//      echo " \n fuck php ?  \n";
      $sql = 'SELECT
     news.id,news.remark,news.title as name,news.image,news.source,news.sourceType,n_type.type_key
FROM mysql85931094_db.hfy_news as news ,
                mysql85931094_db.hfy_news_type as n_type
           where news.type_id = n_type.type_id and n_type.type_key = ? and news.title like \''.$key.'\'
           order by news.id desc  limit ?,?';
      $stmt = mysqli_prepare($conn, $sql);
      mysqli_stmt_bind_param($stmt, "ssdd", $type, $key, $offset, $limit);
    } else {
//      echo " \n fuck fuck fuck  \n";
      $sql = 'SELECT
     news.id,news.remark,news.title as name,news.image,news.source,news.sourceType,n_type.type_key
FROM mysql85931094_db.hfy_news as news , mysql85931094_db.hfy_news_type as n_type
           where news.type_id = n_type.type_id and n_type.type_key = ?
           order by news.id desc limit ?,?';
      $stmt = mysqli_prepare($conn, $sql);
      mysqli_stmt_bind_param($stmt, "sdd", $type, $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);
}