PHP
求PHP挂库3级下拉列表！
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区求PHP挂库3级下拉列表！
QQ号：228944890 跪求大哥大姐了！
那位大哥帮我弄一下额！
数据库为一下3级： 大类联动 小类联动
产品大类：$sqlc="select * from pro_big_class"; ID
产品小类：$sqlc="select * from pro_small_class"; big_id ID
产品信息：$sqlc="select * from product_info"; big_id small_id
一下为我改的2级下拉列表代码:
<script language = "JavaScript">
<!--
var onecount1;
onecount1 = 0;
subcat1 = new Array();
<?
$count1=0;
$sqlc="select * from pro_small_class";
$resultc=$ob->SQL($sqlc);
while($rsc=mysql_fetch_array($resultc))
{
?>
subcat1[<?=$count1;?>] = new Array("<?=$rsc['class_id']?>","<?=$rsc['class_name'];?>");
<?
$count1++;
}
?>
onecount1=<?=$count1?>;
function getCity1(provinceId)
{
document.myform.small_class.length = 0;
var locationid=provinceId;
var i;
document.myform.small_class.options[0] = new Option('请选择','');
for (i=0;i<onecount1;i++)
{
if (subcat1[i][0] == locationid)
{
document.myform.small_class.options[document.myform.small_class.length] = new Option(subcat1[i][1], subcat1[i][1]);
}
}
}
var onecount2;
onecount2 = 0;
subcat2 = new Array();
<?
$count2=0;
$sqlp="select * from product_info";
$resultp=$ob->SQL($sqlp);
while($rsp=mysql_fetch_array($resultp))
{
?>
subcat2[<?=$count2;?>] = new Array("<?=$rsp['small_id']?>","<?=$rsp['name'];?>");
<?
$count2++;
}
?>
onecount2=<?=$count2?>;
function getCity2(provinceIds)
{
document.myform.pro_info.length = 0;
var locationids=provinceIds;
var is;
return document.myform.pro_info.options[document.myform.pro_info.length] = new Option(onecount2, onecount2);
document.myform.pro_info.options[0] = new Option('请选择','');
for (is=0;is<onecount2;is++)
{
if (subcat2[is][0] == locationids)
{
document.myform.pro_info.options[document.myform.pro_info.length] = new Option(subcat2[is][1], subcat2[is][1]);
}
}
}
//-->
</script>
HTML代码：
</select><select name="big_class" id="big_class" onChange="getCity1(document.myform.big_class.options[document.myform.big_class.selectedIndex].value);">
<option>请选择</option>
<?php
$sql="select * from pro_big_class";
$result=$ob->SQL($sql);
while($rs=mysql_fetch_array($result))
{
?>
<option value="<?=$rs["ID"]?>" <?php if($big_id==$rs["ID"])?>>
<?=$rs["class_name"]?>
</option>
<?php
}
?>
</select>
--
<select name="small_class" id="small_class" onChange="getCity2(document.myform.small_class.options[document.myform.small_class.selectedIndex].value);">
<option>请选择</option>
<?php
$sqls="select * from pro_small_class";
$results=$ob->SQL($sqls);
while($rss=mysql_fetch_array($results))
{
?>
<option value="<?=$rss["ID"]?>">
<?=$rss["class_name"]?>
</option>
<?php
}
?>
</select>
<select name="pro_info" id="pro_info">
<option>请选择</option></select>
QQ号：228944890 跪求大哥大姐了！
那位大哥帮我弄一下额！
数据库为一下3级： 大类联动 小类联动
产品大类：$sqlc="select * from pro_big_class"; ID
产品小类：$sqlc="select * from pro_small_class"; big_id ID
产品信息：$sqlc="select * from product_info"; big_id small_id
一下为我改的2级下拉列表代码:
<script language = "JavaScript">
<!--
var onecount1;
onecount1 = 0;
subcat1 = new Array();
<?
$count1=0;
$sqlc="select * from pro_small_class";
$resultc=$ob->SQL($sqlc);
while($rsc=mysql_fetch_array($resultc))
{
?>
subcat1[<?=$count1;?>] = new Array("<?=$rsc['class_id']?>","<?=$rsc['class_name'];?>");
<?
$count1++;
}
?>
onecount1=<?=$count1?>;
function getCity1(provinceId)
{
document.myform.small_class.length = 0;
var locationid=provinceId;
var i;
document.myform.small_class.options[0] = new Option('请选择','');
for (i=0;i<onecount1;i++)
{
if (subcat1[i][0] == locationid)
{
document.myform.small_class.options[document.myform.small_class.length] = new Option(subcat1[i][1], subcat1[i][1]);
}
}
}
var onecount2;
onecount2 = 0;
subcat2 = new Array();
<?
$count2=0;
$sqlp="select * from product_info";
$resultp=$ob->SQL($sqlp);
while($rsp=mysql_fetch_array($resultp))
{
?>
subcat2[<?=$count2;?>] = new Array("<?=$rsp['small_id']?>","<?=$rsp['name'];?>");
<?
$count2++;
}
?>
onecount2=<?=$count2?>;
function getCity2(provinceIds)
{
document.myform.pro_info.length = 0;
var locationids=provinceIds;
var is;
return document.myform.pro_info.options[document.myform.pro_info.length] = new Option(onecount2, onecount2);
document.myform.pro_info.options[0] = new Option('请选择','');
for (is=0;is<onecount2;is++)
{
if (subcat2[is][0] == locationids)
{
document.myform.pro_info.options[document.myform.pro_info.length] = new Option(subcat2[is][1], subcat2[is][1]);
}
}
}
//-->
</script>
HTML代码：
</select><select name="big_class" id="big_class" onChange="getCity1(document.myform.big_class.options[document.myform.big_class.selectedIndex].value);">
<option>请选择</option>
<?php
$sql="select * from pro_big_class";
$result=$ob->SQL($sql);
while($rs=mysql_fetch_array($result))
{
?>
<option value="<?=$rs["ID"]?>" <?php if($big_id==$rs["ID"])?>>
<?=$rs["class_name"]?>
</option>
<?php
}
?>
</select>
--
<select name="small_class" id="small_class" onChange="getCity2(document.myform.small_class.options[document.myform.small_class.selectedIndex].value);">
<option>请选择</option>
<?php
$sqls="select * from pro_small_class";
$results=$ob->SQL($sqls);
while($rss=mysql_fetch_array($results))
{
?>
<option value="<?=$rss["ID"]?>">
<?=$rss["class_name"]?>
</option>
<?php
}
?>
</select>
<select name="pro_info" id="pro_info">
<option>请选择</option></select>
...全文
相关推荐
Ajax实现下拉列表从数据库读取数据级联
Ajax实现下拉列表从数据库读取数据级联
缔梦代挂系统_代挂系统源码_代挂_代挂源码_代挂网最新源码_代挂分站搭建_
php源码.支持5.4支持提现搭建分站...
php 获取select下拉列表框的值
php 如何取得select下拉列表框的值，其实就是需要设置下name属性获取下即可。
三级联动下拉列表框（SELECT）jquery插件（js 三级联动） php版
感谢作者”天天无用“的共享精神，连资源分也是0，受其感染，发布一个php版的
php数组生成html下拉列表的方法
主要介绍了php数组生成html下拉列表的方法,涉及php根据数组动态创建html代码的相关技巧,具有一定参考借鉴价值,需要的朋友可以参考下
