/**
* 無限分類
* 2011/8/24
* kcj
* */
include "../conn/conn.php";
$flpid=$_POST['flpid'];
$fltitle=$_POST['title'];
$fldes=$_POST['des'];
if(isset($_POST['action'])!=''&&$_POST['action']="add"){ // 無限分類(非遞歸),用路徑來判斷分類歸屬(flid=flpid)
$sql2="select flpath from fenlei where flid=".$flpid;
$rst2=mysql_query($sql2);
$row=mysql_fetch_array($rst2,MYSQL_ASSOC);
$flpath=$row['flpath'];
$sql="insert into fenlei (flpid,fltitle,fldes,flpath) value('".$flpid."','".$fltitle."','".$fldes."','".($flpath.'-'.$flpid)."')";
mysql_query($sql);
}
?>
無標題文檔function vaFl(addfl){
if(addfl.title.value==''){
alert("欄目名稱不能為空!");
addfl.title.focus();
return false;
}
if(addfl.des.value==''){
alert("欄目描述不能為空!");
addfl.des.focus();
return false;
}
}
后臺管理->添加分類
上級欄目
請選擇分類
$sql="SELECT*FROM fenlei where flpid=0"; //這一塊只是在下拉列表中,顯示三級分類(可以顯示更多,循環出來就ok了!)
$rs=mysql_query($sql);
while ($row=mysql_fetch_array($rs)) { var_dump($row);
echo "$row[fltitle]";
$sql="select*from fenlei where flpid=$row[flid]";
$rs_son=mysql_query($sql);
while($row_son=mysql_fetch_array($rs_son)){
echo "???$row_son[fltitle]";
$sql="select*from fenlei where flpid=$row_son[flid]";
$rs_son_one=mysql_query($sql);
while($row_son_one=mysql_fetch_array($rs_son_one)){
echo "??????$row_son_one[fltitle]";
}
}
}
?>
欄目名稱*
欄目描述