php无限分类读取多级菜单

//数据库表

include "comm.php";

//获取分类菜单

$arr=getTree();
$arrone=getFlone(59);
$arrtwo=getFltwo(93);
$arrmenu=getFlmenu(59);
print_r($arrmenu);


//获取分类树
function getTree(){
global $db;
$sql="select flid,flpid,flpath,fltitle,fldes,keyword from fenlei order by flid";
$rs=$db->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;
}

?>
include "comm.php";

//获取分类菜单

$arr=getTree();
$arrone=getFlone(59);
$arrtwo=getFltwo(93);
$arrmenu=getFlmenu(59);
print_r($arrmenu);

//获取分类树 www.2cto.com
function getTree(){
global $db;
$sql="select flid,flpid,flpath,fltitle,fldes,keyword from fenlei order by flid";
$rs=$db->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]

 
[html] 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] => 纽约 

                                        ) 

  

                                ) 

  

                        ) 

  

                ) 

  

        ) 

  

) 


摘自 chaojie2009的专栏