qq_41711757 2018-09-15 08:52 采纳率: 37.5%
浏览 448
已采纳

php代码求大佬讲解下每部的意思

<?php
header("Access-Control-Allow-Origin: *"); // 允许任意域名发起的跨域请求
$peopleId = $_POST['peopleId'];
include("connectDB.php");
$cc = " AND peopleId = '$peopleId' ";
$dd = "order by id desc";
if ($peopleId == "") {
$sequery = "SELECT * FROM order WHERE 1=1 ".$dd ;
}else{
$sequery = "SELECT * FROM order WHERE 1=1 ".$cc.$dd ;
}

$result = mysqli_query($dbc,$sequery) or die("Error query");
$i = 0;
while($row = mysqli_fetch_array($result)){
    $resArr['id'] = $row['id'];
    $resArr['userName'] = $row['userName'];
    $resArr['phone'] = $row['phone'];
    $resArr['type'] = $row['type'];
    $resArr['school'] = $row['school'];
    $resArr['day'] = $row['day'];
    $resArr['num'] = $row['num'];
    $resArr['peopleId'] = $row['peopleId'];
    $resArr['peopleName'] = $row['peopleName'];
    $data['content_data'][$i++] = $resArr;
}

mysqli_close($dbc);

echo json_encode($data);

?>

  • 写回答

1条回答 默认 最新

  • 忆之乜 2018-09-15 09:07
    关注

    header("Access-Control-Allow-Origin: *"); // 允许任意域名发起的跨域请求
    $peopleId = $_POST['peopleId'];//POST接收'peopleId'参数
    include("connectDB.php");//包含当前目录下的"connectDB.php"文件
    $cc = " AND peopleId = '$peopleId' ";//sql语句
    $dd = "order by id desc";//sql语句
    //根据条件选择sql语句
    if ($peopleId == "") {
    $sequery = "SELECT * FROM order WHERE 1=1 ".$dd ;//倒序选择order表所有数据
    }else{
    $sequery = "SELECT * FROM order WHERE 1=1 ".$cc.$dd ;//选择peopleId = '$peopleId' 数据
    }
    $result = mysqli_query($dbc,$sequery) or die("Error query");//执行sql语句,报错停止运行
    //根据结果组装数组
    $i = 0;
    while($row = mysqli_fetch_array($result)){
    $resArr['id'] = $row['id'];
    $resArr['userName'] = $row['userName'];
    $resArr['phone'] = $row['phone'];
    $resArr['type'] = $row['type'];
    $resArr['school'] = $row['school'];
    $resArr['day'] = $row['day'];
    $resArr['num'] = $row['num'];
    $resArr['peopleId'] = $row['peopleId'];
    $resArr['peopleName'] = $row['peopleName'];
    $data['content_data'][$i++] = $resArr;
    }
    mysqli_close($dbc);//关闭数据库连接

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?
  • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算