getSolution.php 766 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. include('../conn_mysqli.php');
  3. include('../phpMode/rcodeMap.php');
  4. $id = $_GET['id'];
  5. header('Content-Type:text/json;charset=utf-8;');
  6. $resObj = array(
  7. 'rcode'=>Rcode_OK,
  8. 'data'=>"",
  9. 'msg'=>'ok'
  10. );
  11. if(!isset($_GET['id'])){
  12. $resObj['rcode'] = Rcode_NotParam;
  13. $resObj['data'] = "";
  14. $resObj['msg'] = "id is must set";
  15. echo json_encode($resObj);
  16. exit;
  17. }
  18. $conn = createConn();
  19. $sql = 'SELECT news.* FROM
  20. mysql85931094_db.hfy_news as news
  21. WHERE news.id = ?';
  22. // 创建stmt
  23. $stmt = mysqli_prepare($conn, $sql);
  24. mysqli_stmt_bind_param($stmt, "d",$id);
  25. mysqli_stmt_execute($stmt);
  26. $res = mysqli_stmt_get_result($stmt);
  27. $rs = mysqli_fetch_object($res);
  28. mysqli_close($conn);
  29. $resObj['data'] = $rs ;
  30. echo json_encode($resObj);