最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
一个用数据库的php二级联动
时间:2022-07-02 10:07:04 编辑:袖梨 来源:一聚教程网
/*******************************************
**********功能:php二级联动菜单*************
**********作者:冲星*************************
**********Email:[email protected]**************
**********日期:2004/10/02******************
**********请转载时保留版权信息**************
*******************************************/
require_once('db.inc.php');//数据库连接
$db=new hq_online;
$db1=new hq_online;
$db->query("select * from news_bclass order by id desc");
$fMenu="";
$fValue="";
while($db->next_record()){
$fMenu.=""".$db->Record["bname"]."",";
$fValue.=""".$db->Record["id"]."",";
}
$fMenu=substr($fMenu,0,(strlen($fMenu)-1));
$fMenu="[".$fMenu."]";//*****************************得到var fMenu
$fValue=substr($fValue,0,(strlen($fValue)-1));
$fValue="[".$fValue."]";//*****************************得到var fValue
//得到*****************************var sMenu
$db->query("select * from news_bclass order by id desc");
while($db->next_record()){
$parentid=$db->Record["id"];
$db1->query("select * from news_sclass where parentid='$parentid' order by parentid desc");
while($db1->next_record()){
$num=$db1->num_rows();
$i++;
$sMenu.=""".$db1->Record["sname"]."",";
if($i==$num){
$sMenu="[".$sMenu."],[";
$i=0;
}
}
}
$sMenu.="]";
$sMenu=str_replace("",]",""]",$sMenu);
$sMenu=str_replace(",[]","]",$sMenu);
if((substr($sMenu,0,2))=="[""){
$sMenu="[".$sMenu;
}else{
$sMenu=preg_replace("/[{3,}/is","[[1",$sMenu);//匹配
**********功能:php二级联动菜单*************
**********作者:冲星*************************
**********Email:[email protected]**************
**********日期:2004/10/02******************
**********请转载时保留版权信息**************
*******************************************/
require_once('db.inc.php');//数据库连接
$db=new hq_online;
$db1=new hq_online;
$db->query("select * from news_bclass order by id desc");
$fMenu="";
$fValue="";
while($db->next_record()){
$fMenu.=""".$db->Record["bname"]."",";
$fValue.=""".$db->Record["id"]."",";
}
$fMenu=substr($fMenu,0,(strlen($fMenu)-1));
$fMenu="[".$fMenu."]";//*****************************得到var fMenu
$fValue=substr($fValue,0,(strlen($fValue)-1));
$fValue="[".$fValue."]";//*****************************得到var fValue
//得到*****************************var sMenu
$db->query("select * from news_bclass order by id desc");
while($db->next_record()){
$parentid=$db->Record["id"];
$db1->query("select * from news_sclass where parentid='$parentid' order by parentid desc");
while($db1->next_record()){
$num=$db1->num_rows();
$i++;
$sMenu.=""".$db1->Record["sname"]."",";
if($i==$num){
$sMenu="[".$sMenu."],[";
$i=0;
}
}
}
$sMenu.="]";
$sMenu=str_replace("",]",""]",$sMenu);
$sMenu=str_replace(",[]","]",$sMenu);
if((substr($sMenu,0,2))=="[""){
$sMenu="[".$sMenu;
}else{
$sMenu=preg_replace("/[{3,}/is","[[1",$sMenu);//匹配
相关文章
- CF手游boss卡上限重置时间攻略 04-25
- 蛋仔派对爆爆狐技能最强搭配指南 04-25
- 深空之眼震离月读搭配方案推荐 04-25
- 以闪亮之名玩呐第13章如何快速通关 04-25
- 决胜巅峰大铁罐最强怎样出装最合适 04-25
- 以闪亮之名食谱领悟流程哪几种 04-25