PHP+Mysql二级动态联动菜单
来源:互联网 发布:精通qt4编程 高清pdf 编辑:程序博客网 时间:2024/04/29 10:00
<!--基于php+mysql的二级动态级联菜单(By:sunlion)+++开始-->
<FORM name="FormData1" METHOD="POST" action="savenews.php">
<select name="c_idc" onChange="getCity2(document.FormData1.c_idc.options[document.FormData1.c_idc.selectedIndex].value);" size="1">
<option selected>请选择</option>
<?
$result4=mysql_query("select * from bigsort group by Id order by Id desc";
while($rs1=mysql_fetch_array($result4)){
?>
<option value="<?=$rs1['Id'];?>"><?=$rs1['bigsortname'];?></option>
<?
}
?>
</select>
<select name="list_id">
<option selected value="">请选择</option>
</select>
<script language = "JavaScript">
var onecount2;
onecount2 = 0;
subcat2 = new Array();
<?
$count2=0;
$result5=mysql_query("select * from smallsort order by bigsortid desc";
while($rs2=mysql_fetch_array($result5)){
?>
subcat2[<?=$count2;?>] = new Array("<?=$rs2['smallsortname'];?>","<?=$rs2['bigsortid'];?>","<?=$rs2['smallsortname'];?><?=$rs2['bigsortid'];?>";
<?
$count2++;
}
?>
onecount2=<?=$count2?>;
function getCity2(provinceId)
{
document.FormData1.list_id.length = 0;
var locationid=provinceId;
var i;
document.FormData1.list_id.options[0] = new Option('请选择','');
for (i=0;i<onecount2;i++)
{
if (subcat2[i][1] == locationid)
{
document.FormData1.list_id.options[document.FormData1.list_id.length] = new Option(subcat2[i][2], subcat2[i][0]);
}
}
}
</script>
</form>
接受页面如下接受数据
$bigsort=$_POST["c_idc"];
$smallsort=$_POST["list_id"];
<!--基于php+mysql的二级动态级联菜单(By:sunlion)+++结束-->
- PHP+Mysql二级动态联动菜单
- PHP二级联动下拉菜单
- jQuery+PHP+MySQL实现二级联动下拉菜单
- jQuery+PHP+MySQL实现二级联动下拉菜单
- PHP&MySQL基于数据库的二级联动下拉菜单
- php二级联动菜单改动版
- php带有数据库的二级联动菜单
- 经典的php二级联动菜单
- PHP地区二级联动下拉菜单
- js+jsp+mysql二级联动菜单
- php二级联动菜单(级联菜单),带数据库信息
- 二级联动菜单详解
- 二级联动菜单详解
- asp联动二级菜单
- .net 二级联动菜单
- js二级联动菜单
- 二级联动菜单
- Ajax二级菜单联动
- ORACLE 参数和Unix Kernal关系
- XML与数据库
- Linux Command Line Encryption
- wine中文支持设置
- string和int间的类型转换
- PHP+Mysql二级动态联动菜单
- mysql注入时的注释处理
- Visual C#中用WMI获取远程计算机信息
- codebehind与codefile
- 绝好的发明专利项目——实时支付软件
- Datatable 中的数据查询(查询不重复记录)
- c#如何获得cpu,硬盘的物理序列号
- checkbox with jquery click function not checked problem
- C#入门经典(第三版)十一章练习题答案