php原生mysql多表多条件查询
//测试数据展示
$name = '主设备B';
$qu = 'SELECT * FROM `main_equipment` WHERE status="1"';
$qu.= " and id=".$main_number;
$qu.= " and name like '%{$name}%'";
//执行查询
$result = mysqli_query($connection, $qu);
if(!$result) {
exit('查询子设备不存在!');
}else {
// 展示子设备数据
$sub = array(); // 转为数组
while($row = mysqli_fetch_assoc($result)) {
$sub[] = $row;
}
echo json_encode($sub);
}
多表查询:
// $query = mysqli_query($connection,'select a.name as main_name,b.* from main_equipment as a, sub_equipment as b where a.id = b.m_id and b.id='.$sub_equipment);
// if(!$query) {
// exit('查询子设备不存在!');
// }else {
// // 展示子设备数据
// $sub = array(); // 转为数组
// while($row = mysqli_fetch_assoc($query)) {
// $sub[] = $row;
// }
// echo json_encode($sub);
// }
数据查询时,关联的数据,转为数组,json进行输出展示:
//选择其中一个子设备,子设备a1,a2,a3,a4
$sub_equipment = 1;
$id.= "and b.id=".$sub_equipment;
// $query = mysqli_query($connection,'select a.name as main_name,b.* from main_equipment as a, sub_equipment as b where a.id = b.m_id and b.id='.$sub_equipment);
// if(!$query) {
// exit('查询子设备不存在!');
// }else {
// // 展示子设备数据
// $sub = array(); // 转为数组
// while($row = mysqli_fetch_assoc($query)) {
// $sub[] = $row;
// }
// echo json_encode($sub);
// }
获取数组中指定的字段的值:
**
**
// 对子设备进行操作,判断该子设备的工作模式,C为发送,B可发送可接收,AP终止,传递过程中不构成回环
// echo $obtain_sub_equipment;
// var_dump($sub[0]['mode_id']);
$mode_id = $sub[0]['mode_id'];
echo $mode_id;