php - 想要得到如下结果。如何为此编写查询
问题描述
{"result": [
{
"room_id": "1",
"floor_id": "1",
"flat_id": "1",
"room_name": "Room1",
"no_of_cots": "4",
"cot_info":[{"cot_id": "1",
"cot_name": "COT1",
"cot_status": "1"},
{"cot_id": "2",
"cot_name": "COT2",
"cot_status": "1"}],
"flat_name": "Sumangali PG",
"floor_name": "GroundFloor"
},
{
"room_id": "2",
"floor_id": "1",
"flat_id": "1",
"room_name": "Room2",
"no_of_cots": "2",
"cot_info":[{"cot_id": "1",
"cot_name": "COT1",
"cot_status": "1"},
{"cot_id": "2",
"cot_name": "COT2",
"cot_status": "1"}],
"flat_name": "Sumangali PG",
"floor_name": "GroundFloor"
} ]
}
解决方案
好的,您可以使用第一页的两页进行处理,查询示例
应该是这样的,然后您可以将其添加到数组中,然后解码数组并像下面的示例一样进行回显:
//page source
$query ='select room_id,floor_id,flat_id,room_name,no_of_cots,cot_info,cot_id,cot_name,cot_status,flat_name,floor_name
from table1 ,table2,table3,table4 where table1.id=table2.id and table2.id=table3.id and table4.id=table3.id';
$result = mysqli_query($conn,$query);
$array_list=array();
while($row = mysqli_fetch_array($result))
{
$array_list['room_id']=$row;
$array_list['floor_id']=$row;
$array_list['flat_id']=$row;
$array_list['room_name']=$row;
$array_list['cot_info']=$row;
$array_list['cot_name']=$row;
$array_list['cot_id']=$row;
$array_list['cot_status']=$row;
$array_list['flat_name']=$row;
$array_list['floor_name']=$row;
}
$json_data = array(
"result" => $array_list,
);
echo json_encode($json_data);
// page 2
$content='{"result": [ { "room_id": "1", "floor_id": "1", "flat_id": "1", "room_name": "Room1", "no_of_cots": "4", "cot_info":[{"cot_id": "1", "cot_name": "COT1", "cot_status": "1"}, {"cot_id": "2", "cot_name": "COT2", "cot_status": "1"}], "flat_name": "Sumangali PG", "floor_name": "GroundFloor" }, { "room_id": "2", "floor_id": "1", "flat_id": "1", "room_name": "Room2", "no_of_cots": "2", "cot_info":[{"cot_id": "1", "cot_name": "COT1", "cot_status": "1"}, {"cot_id": "2", "cot_name": "COT2", "cot_status": "1"}], "flat_name": "Sumangali PG", "floor_name": "GroundFloor" } ] }';
$json=json_decode($content);
foreach($json->result as $row)
{
print_r($row);
}
推荐阅读
- dbt - dbt:sql_header 宏限制与查询注释
- angular - 许多图标按钮导致网站速度急剧下降
- python - 使用来自其他函数的变量
- javascript - CRA 项目中是否有一种简单的方法可以封装特定的文件夹层次结构?
- tsql - sp_executesql 参数列表中的表变量
- python - 带有二维数组的curve_fit()
- python-3.x - 另一个 IDE 中 HackerRank 中的副本输入(sublime text 或 spyder)
- symfony - Symfony 验证器的注释返回“注释从未导入异常”
- actionscript-3 - 数字标牌 - 大约 2 小时后视频变慢
- machine-learning - 深度学习中的大量虚拟变量