hfysite/phpAPi/addNewsRead.php

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

$id = $_GET['id'];

header('Content-Type:text/json;charset=utf-8;');
$resObj = array(
  'rcode'=>Rcode_OK,
  'data'=>"",
  'msg'=>'ok'
);
if(!isset($_GET['id'])){
  $resObj['rcode'] = Rcode_NotParam;
  $resObj['data'] = "";
  $resObj['msg'] = "id is must set";
  echo json_encode($resObj);
  exit;
}

$conn = createConn();
$sql = 'UPDATE mysql85931094_db.hfy_news SET hits = hits + 1 WHERE id = ? limit 1';
// 创建stmt
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, "s",$id);
mysqli_stmt_execute($stmt);
$res = mysqli_stmt_get_result($stmt);
$rs = mysqli_fetch_object($res);
mysqli_close($conn);
$resObj['data'] = $rs ;
echo json_encode($resObj);