求解决,用php语言遍历数据库生成以下结构的 json 数据,[
{
"text":"服务",
"children":
[
{"text":"苏州","id":"1"},
{"text":"北京","id":"2"}
]
},
{
"text":"传单",
"children":
[
{"text":"上海","id":"3"},
{"text":"广东","id":"4"}
]
}
]
{
"text":"服务",
"children":
[
{"text":"苏州","id":"1"},
{"text":"北京","id":"2"}
]
},
{
"text":"传单",
"children":
[
{"text":"上海","id":"3"},
{"text":"广东","id":"4"}
]
}
]
foreach ($text1 as $row1){ $json[] = array(
"text" => $row1["name"],
"children" => array(
array("text" => "苏州","id" => "1",),
array("text" => "北京","id" => "2",)
)
);
}请按这个接着解决类二遍历的问题
$json[] = array(
"text" => $row1["name"],
"children" => my_select("select * from xx where 关联ID={$row1['id']}")
);
}
$category是一个三维数组,map和foreach一样,你自己看着改吧
$list = $category->map(function ($item) {
$er =$item->children->map(function ($res){
$san =$res->children->map(function ($san){
return [
'cate_id' => $san->cate_id,
'text' => $san->cate_name,
'children' =>''
];
}); return [
'cate_id' => $res->cate_id,
'text' => $res->cate_name,
'children' =>$san
];
});
$data = [
'cate_id' => $item->cate_id,
'text' => $item->cate_name,
'children' =>$er
];
return $data;
})->toJson(JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES);
前两步没问题吧
最后一步,你想原生Php写,不借助框架还是有难度的,尤其多层递归数组。
网上有专门递归转json的函数。