php带有数据库的二级联动菜单.doc

php带有数据库的二级联动菜单php带有数据库的二级联动菜单2010-12-09 15：49?php class myconnvar$conn；var$result；function myconn()$this-conn=mysql_connect(localhost,root,1234)；mysql_select_db(allin,$this-conn)；function process($sql)mysql_query(set names gbk)；$result=mysql_query($sql)；return$result；?form name=frmselect name=s1onChange=redirec(document.frm.s1.options.selectedIndex)option selected请选择/option?php$conn=new myconn()；$sql=select*from topclass where parentid=0；$result=$conn-process($sql)；while($data=mysql_fetch_array($result)?option value=?php echo$data0；?php echo$data2；?/option?php?/select select name=s2option value=请选择selected请选择/option/select/form script language=javascript/获取一级菜单长度var select1_len=document.frm.s1.options.length；var select2=new Array(select1_len)；/把一级菜单都设为数组for(i=0；i select1_len；i+)select2i=new Array()；?php$conn=new myconn()；$sql=select*from topclass where parentid=0；$result=$conn-process($sql)；$i=1；while($data=mysql_fetch_array($result)$sql=select name from topclass where parentid=$data0；$result2=$conn-process($sql)；?select2?php echo($i)；?0=new Option(=请选择=,)；?$j=1；while($data2=mysql_fetch_array($result2)?select2?php echo($i)；?php echo$j；?=new Option(?php echo$data20；?,?php echo$data20；?)；?php$j+；$i+；?function redirec(x)document.frm.s2.length=1；var temp=document.frm.s2；for(i=0；i select2x.length；i+)temp.optionsi=new Option(select2xi.text,select2xi.value)；if(select2x.length=0)temp.options0=new Option(