Home > Article > Backend Development > A PHP secondary linkage using a database_PHP tutorial
A PHP secondary linkage using a database_PHP tutorial
- WBOYOriginal
- 2016-07-20 10:59:421153browse
/*********************************************
**********Function: PHP secondary linkage menu************
**********Author: Chongxing******************************
**********Email:njj@nuc.edu.cn******************
**********Date: 2004/10/02******************
**********Please keep the copyright information when reprinting******************
*******************************************/
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);//匹配