//数据库表
[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
关键字词: