自由手記

<?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,key 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;
}

?>