php无限分类读取多级菜单

2015.12.19 -

0_1322029496f1V0
query($sql);
$data=array();
while ($row=$db->fetch_array($rs)){
$data[]=$row;
}
return $data;
}
//活动一级分类 注意在这顶级分类id为 59
function getFlone($flpid){
global $db;
$sql=”select * from fenlei where flpid={$flpid} order by flid”;
$rs=$db->query($sql);
$data=array();
while ($row=$db->fetch_array($rs)){
$data[]=$row;
}
return $data;
}
//活动二级分类
function getFltwo($flpid){
global $db;
$sql=”select * from fenlei where flpid={$flpid} order by flid”;
$rs=$db->query($sql);
$data=array();
while ($row=$db->fetch_array($rs)){
$data[]=$row;
}
return $data;
}
//循环获取菜单,此数据库顶级父分类id为 59
function getFlmenu($flpid){
global $db;
$arr=getFlone($flpid);

foreach ($arr as &$v) {
$arrt=getFlone($v[‘flid’]);

foreach ($arrt as &$vl){
$arrtt=getFlone($vl[‘flid’]);
$vl[‘tt’]=$arrtt;
}
$v[‘two’]=$arrt;
}
return $arr;
}

?>

[php] view plaincopy


Array
(
[0] => Array
(
[0] => 93
[flid] => 93
[1] => 59
[flpid] => 59
[2] => 国内新闻
[fltitle] => 国内新闻
[3] => 0-59
[flpath] => 0-59
[4] => 国内新闻
[fldes] => 国内新闻
[5] => 国内新闻
[keyword] => 国内新闻
[two] => Array
(
[0] => Array
(
[0] => 98
[flid] => 98
[1] => 93
[flpid] => 93
[2] => 时政
[fltitle] => 时政
[3] => 0-59-93
[flpath] => 0-59-93
[4] => 时政
[fldes] => 时政
[5] => 时政
[keyword] => 时政
[tt] => Array
(
[0] => Array
(
[0] => 102
[flid] => 102
[1] => 98
[flpid] => 98
[2] => 医疗
[fltitle] => 医疗
[3] => 0-59-93-98
[flpath] => 0-59-93-98
[4] => 医疗
[fldes] => 医疗
[5] => 医疗
[keyword] => 医疗
)

[1] => Array
(
[0] => 103
[flid] => 103
[1] => 98
[flpid] => 98
[2] => 卫生
[fltitle] => 卫生
[3] => 0-59-93-98
[flpath] => 0-59-93-98
[4] => 卫生
[fldes] => 卫生
[5] => 卫生
[keyword] => 卫生
)

)

)

[1] => Array
(
[0] => 99
[flid] => 99
[1] => 93
[flpid] => 93
[2] => 民生
[fltitle] => 民生
[3] => 0-59-93
[flpath] => 0-59-93
[4] => 民生
[fldes] => 民生
[5] => 民生
[keyword] => 民生
[tt] => Array
(
[0] => Array
(
[0] => 104
[flid] => 104
[1] => 99
[flpid] => 99
[2] => 税费
[fltitle] => 税费
[3] => 0-59-93-99
[flpath] => 0-59-93-99
[4] => 税费
[fldes] => 税费
[5] => 税费
[keyword] => 税费
)

[1] => Array
(
[0] => 105
[flid] => 105
[1] => 99
[flpid] => 99
[2] => 住房
[fltitle] => 住房
[3] => 0-59-93-99
[flpath] => 0-59-93-99
[4] => 住房
[fldes] => 住房
[5] => 住房
[keyword] => 住房
)

)

)

)

)

[1] => Array
(
[0] => 96
[flid] => 96
[1] => 59
[flpid] => 59
[2] => 娱乐新闻
[fltitle] => 娱乐新闻
[3] => 0-59
[flpath] => 0-59
[4] => 娱乐新闻
[fldes] => 娱乐新闻
[5] => 娱乐新闻
[keyword] => 娱乐新闻
[two] => Array
(
[0] => Array
(
[0] => 100
[flid] => 100
[1] => 96
[flpid] => 96
[2] => 八卦
[fltitle] => 八卦
[3] => 0-59-96
[flpath] => 0-59-96
[4] => 八卦
[fldes] => 八卦
[5] => 八卦
[keyword] => 八卦
[tt] => Array
(
)

)

[1] => Array
(
[0] => 101
[flid] => 101
[1] => 96
[flpid] => 96
[2] => 明星
[fltitle] => 明星
[3] => 0-59-96
[flpath] => 0-59-96
[4] => 明星
[fldes] => 明星
[5] => 明星
[keyword] => 明星
[tt] => Array
(
)

)

)

)

[2] => Array
(
[0] => 97
[flid] => 97
[1] => 59
[flpid] => 59
[2] => 国外新闻
[fltitle] => 国外新闻
[3] => 0-59
[flpath] => 0-59
[4] => 国外新闻
[fldes] => 国外新闻
[5] => 国外新闻
[keyword] => 国外新闻
[two] => Array
(
[0] => Array
(
[0] => 106
[flid] => 106
[1] => 97
[flpid] => 97
[2] => 美国
[fltitle] => 美国
[3] => 0-59-97
[flpath] => 0-59-97
[4] => 美国
[fldes] => 美国
[5] => 美国
[keyword] => 美国
[tt] => Array
(
[0] => Array
(
[0] => 107
[flid] => 107
[1] => 106
[flpid] => 106
[2] => 纽约
[fltitle] => 纽约
[3] => 0-59-97-106
[flpath] => 0-59-97-106
[4] => 纽约
[fldes] => 纽约
[5] => 纽约
[keyword] => 纽约
)

)

)

)

)

)

阅 593
0

已关闭回复!

目前国内用dedecms做网站优化的已经很普遍了,但是都没有看到一套针对dedecms系统的优化方案图,现把用