//數據庫表
<?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] => 紐約 ) ) ) ) ) )PHP編程
鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。
新聞熱點
疑難解答
