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 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 LiBeAs的带隙等于0.997eV,计算阴离子的N和P
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 来真人,不要ai!matlab有关常微分方程的问题求解决,
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误
  • ¥199 rust编程架构设计的方案 有偿
  • ¥15 回答4f系统的像差计算