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);//关闭数据库连接

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

报告相同问题?

悬赏问题

  • ¥15 matlab在安装时报错 无法找到入口 无法定位程序输入点
  • ¥15 收益高的广告联盟有哪些
  • ¥15 Android Studio webview 的使用问题, 播放器横屏全屏
  • ¥15 删掉jdk后重新下载,Java web所需要的eclipse无法使用
  • ¥15 uniapp正式环境中通过webapi将本地数据推送到设备出现的跨域问题
  • ¥15 xui建立节点,显示错误
  • ¥15 关于#单片机#的问题:开始、复位、十进制的功能可以实现,但是切换八进制的功能无法实现(按下按键也没有效果),把初始状态调成八进制,也是八进制可以实现但是切换到十进制不行(相关搜索:汇编语言|计数器)
  • ¥15 VINS-Mono或Fusion中feature_manager中estimated_depth是特征的深度还是逆深度?
  • ¥15 谷歌浏览器如何备份抖音网页数据
  • ¥15 分别有什么商家下面需要非常多的骑手为它工作?