//数据库表
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]
<br> <pre class="brush:php;toolbar:false">[html] Array <br> ( <br> [0] => Array <br> ( <br> [0] => 93 <br> [flid] => 93 <br> [1] => 59 <br> [flpid] => 59 <br> [2] => 国内新闻 <br> [fltitle] => 国内新闻 <br> [3] => 0-59 <br> [flpath] => 0-59 <br> [4] => 国内新闻 <br> [fldes] => 国内新闻 <br> [5] => 国内新闻 <br> [keyword] => 国内新闻 <br> [two] => Array <br> ( <br> [0] => Array <br> ( <br> [0] => 98 <br> [flid] => 98 <br> [1] => 93 <br> [flpid] => 93 <br> [2] => 时政 <br> [fltitle] => 时政 <br> [3] => 0-59-93 <br> [flpath] => 0-59-93 <br> [4] => 时政 <br> [fldes] => 时政 <br> [5] => 时政 <br> [keyword] => 时政 <br> [tt] => Array <br> ( <br> [0] => Array <br> ( <br> [0] => 102 <br> [flid] => 102 <br> [1] => 98 <br> [flpid] => 98 <br> [2] => 医疗 <br> [fltitle] => 医疗 <br> [3] => 0-59-93-98 <br> [flpath] => 0-59-93-98 <br> [4] => 医疗 <br> [fldes] => 医疗 <br> [5] => 医疗 <br> [keyword] => 医疗 <br> ) <br> <br> [1] => Array <br> ( <br> [0] => 103 <br> [flid] => 103 <br> [1] => 98 <br> [flpid] => 98 <br> [2] => 卫生 <br> [fltitle] => 卫生 <br> [3] => 0-59-93-98 <br> [flpath] => 0-59-93-98 <br> [4] => 卫生 <br> [fldes] => 卫生 <br> [5] => 卫生 <br> [keyword] => 卫生 <br> ) <br> <br> ) <br> <br> ) <br> <br> [1] => Array <br> ( <br> [0] => 99 <br> [flid] => 99 <br> [1] => 93 <br> [flpid] => 93 <br> [2] => 民生 <br> [fltitle] => 民生 <br> [3] => 0-59-93 <br> [flpath] => 0-59-93 <br> [4] => 民生 <br> [fldes] => 民生 <br> [5] => 民生 <br> [keyword] => 民生 <br> [tt] => Array <br> ( <br> [0] => Array <br> ( <br> [0] => 104 <br> [flid] => 104 <br> [1] => 99 <br> [flpid] => 99 <br> [2] => 税费 <br> [fltitle] => 税费 <br> [3] => 0-59-93-99 <br> [flpath] => 0-59-93-99 <br> [4] => 税费 <br> [fldes] => 税费 <br> [5] => 税费 <br> [keyword] => 税费 <br> ) <br> <br> [1] => Array <br> ( <br> [0] => 105 <br> [flid] => 105 <br> [1] => 99 <br> [flpid] => 99 <br> [2] => 住房 <br> [fltitle] => 住房 <br> [3] => 0-59-93-99 <br> [flpath] => 0-59-93-99 <br> [4] => 住房 <br> [fldes] => 住房 <br> [5] => 住房 <br> [keyword] => 住房 <br> ) <br> <br> ) <br> <br> ) <br> <br> ) <br> <br> ) <br> <br> [1] => Array <br> ( <br> [0] => 96 <br> [flid] => 96 <br> [1] => 59 <br> [flpid] => 59 <br> [2] => 娱乐新闻 <br> [fltitle] => 娱乐新闻 <br> [3] => 0-59 <br> [flpath] => 0-59 <br> [4] => 娱乐新闻 <br> [fldes] => 娱乐新闻 <br> [5] => 娱乐新闻 <br> [keyword] => 娱乐新闻 <br> [two] => Array <br> ( <br> [0] => Array <br> ( <br> [0] => 100 <br> [flid] => 100 <br> [1] => 96 <br> [flpid] => 96 <br> [2] => 八卦 <br> [fltitle] => 八卦 <br> [3] => 0-59-96 <br> [flpath] => 0-59-96 <br> [4] => 八卦 <br> [fldes] => 八卦 <br> [5] => 八卦 <br> [keyword] => 八卦 <br> [tt] => Array <br> ( <br> ) <br> <br> ) <br> <br> [1] => Array <br> ( <br> [0] => 101 <br> [flid] => 101 <br> [1] => 96 <br> [flpid] => 96 <br> [2] => 明星 <br> [fltitle] => 明星 <br> [3] => 0-59-96 <br> [flpath] => 0-59-96 <br> [4] => 明星 <br> [fldes] => 明星 <br> [5] => 明星 <br> [keyword] => 明星 <br> [tt] => Array <br> ( <br> ) <br> <br> ) <br> <br> ) <br> <br> ) <br> <br> [2] => Array <br> ( <br> [0] => 97 <br> [flid] => 97 <br> [1] => 59 <br> [flpid] => 59 <br> [2] => 国外新闻 <br> [fltitle] => 国外新闻 <br> [3] => 0-59 <br> [flpath] => 0-59 <br> [4] => 国外新闻 <br> [fldes] => 国外新闻 <br> [5] => 国外新闻 <br> [keyword] => 国外新闻 <br> [two] => Array <br> ( <br> [0] => Array <br> ( <br> [0] => 106 <br> [flid] => 106 <br> [1] => 97 <br> [flpid] => 97 <br> [2] => 美国 <br> [fltitle] => 美国 <br> [3] => 0-59-97 <br> [flpath] => 0-59-97 <br> [4] => 美国 <br> [fldes] => 美国 <br> [5] => 美国 <br> [keyword] => 美国 <br> [tt] => Array <br> ( <br> [0] => Array <br> ( <br> [0] => 107 <br> [flid] => 107 <br> [1] => 106 <br> [flpid] => 106 <br> [2] => 纽约 <br> [fltitle] => 纽约 <br> [3] => 0-59-97-106 <br> [flpath] => 0-59-97-106 <br> [4] => 纽约 <br> [fldes] => 纽约 <br> [5] => 纽约 <br> [keyword] => 纽约 <br> ) <br> <br> ) <br> <br> ) <br> <br> ) <br> <br> ) <br> <br> ) <br> 摘自 chaojie2009的专栏
Datenbank drei Paradigmen
So löschen Sie eine Datenbank
So stellen Sie eine Verbindung zur Datenbank in VB her
So öffnen Sie eine PHP-Datei
MySQL-Datenbank wiederherstellen
So stellen Sie eine Verbindung zum Zugriff auf die Datenbank in VB her
So entfernen Sie die ersten paar Elemente eines Arrays in PHP
Was tun, wenn die PHP-Deserialisierung fehlschlägt?
![[Web-Frontend] Node.js-Schnellstart](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
