爱资料 网 欢迎您的到来,我们在这里提供了免费网页模板、编程资料、开发资料、开发软件、在线工具
主页 > 编程资料 > PHP > php 无限分类读取多级菜单

php 无限分类读取多级菜单

作者:网络 更新:2018-06-06 00:52:43 阅读:187次

//数据库表

 

[php] view plaincopy

<?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;  
}  
  
?>
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] => 纽约  
                                        )  
   
                                )  
   
                        )  
   
                )  
   
        )  
   
)



原文地址:http://blog.csdn.net/chaojie2009/article/details/7004031

Tag:
分享:
0