如果bigtype为空只绑定A
A
aaaaaa
bbbbb
cccccc比如选了aaaaa后跳转到
index.php?bigtype=aaaaa
然后根据bigtype给B绑定它的值
当然A也要重新来了 把bigtype的值置为A的选定值
A
aaaaaa
bbbbb
cccccc比如选了aaaaa后跳转到
index.php?bigtype=aaaaa
然后根据bigtype给B绑定它的值
当然A也要重新来了 把bigtype的值置为A的选定值
/* 与服务器交互的写法 */$conn = mysql_connect("localhost","root",""); // 连接数据库
mysql_select_db("tmp"); // 选择库if(!isset($_GET['key'])) { // 检查是否有传递参数
$sql = "select * from menu where parent_id=0";
$rs = mysql_query($sql);
$str = "";
while($row = mysql_fetch_array($rs)) // 循环构造初始信息
$str .= "<option value='{$row['id']}'>{$row['name']}\n";
}else { // 有,产生脚本代码
$sql = "select * from menu where parent_id={$_GET['key']}";
$rs = mysql_query($sql);
$obj = substr($_GET['obj'],0,-1) . (substr($_GET['obj'],-1)+1);
$str = "$obj.options.length = 0;\n";
while($row = mysql_fetch_array($rs))
$str .= "$obj.options[$obj.options.length] = new Option('{$row['name']}',{$row['id']});\n";
echo $str;
//本节用于调试,可通过 test.txt 文件检查输出的是否为合法的js脚本
$fp = fopen("test.txt","w");
fwrite($fp,$str);
fclose($fp); exit;
}
?>
本方法通过改变script标记的src属性来达到动态修改列表框的内容<br>
<script id="sensele" src=""></script>
<script>
function loadsele(v) {
var s = v.options[v.selectedIndex].value;
sensele.src = "?obj="+v.id+"&key="+s;
}
</script>
<select id="sele1" onchange="loadsele(this)">
<?php echo $str; ?>
</select>
<select id="sele2" onchange="loadsele(this)">>
</select>
<select id="sele3">
</select>#
# 数据表的结构 `menu`
#CREATE TABLE menu (
id tinyint(4) NOT NULL auto_increment,
parent_id tinyint(4) NOT NULL default '0',
name varchar(20) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;#
# 导出下面的数据库内容 `menu`
#INSERT INTO menu VALUES (1, 0, '人事管理');
INSERT INTO menu VALUES (2, 0, '通讯交流');
INSERT INTO menu VALUES (3, 1, '档案管理');
INSERT INTO menu VALUES (4, 1, '考勤管理');
INSERT INTO menu VALUES (5, 2, '通讯录');
INSERT INTO menu VALUES (6, 2, '网络会议');
INSERT INTO menu VALUES (7, 3, '新增档案');
INSERT INTO menu VALUES (8, 3, '查询档案');
INSERT INTO menu VALUES (9, 3, '删除档案');
INSERT INTO menu VALUES (10, 5, '新增通讯记录');
INSERT INTO menu VALUES (11, 7, '档案新增');
{
var one0_val=new Array(1);
var one0_name=new Array(1);
one7_val[0]='0801';
one7_name[0]='南京市';
one7_val[1]='0802';
one7_name[1]='无锡市';
one7_val[2]='0803';
one7_name[2]='徐州市';
one7_val[3]='0804';
one7_name[3]='常州市';
one7_val[4]='0805';
one7_name[4]='苏州市';
one7_val[5]='0806';
one7_name[5]='南通市';
one7_val[6]='0807';
one7_name[6]='连云港市';
one7_val[7]='0808';
one7_name[7]='淮阴市';
one7_val[8]='0809';
one7_name[8]='盐城市';
one7_val[9]='0810';
one7_name[9]='扬州市';
one7_val[10]='0811';
one7_name[10]='镇江市';
one7_val[11]='0812';
one7_name[11]='泰州市';
one7_val[12]='0813';
one7_name[12]='宿迁市';
var one8_val=new Array(21);
var one8_name=new Array(21);
one8_val[0]='0901';
one8_name[0]='广州市';
one8_val[1]='0902';
one8_name[1]='深圳市';
one8_val[2]='0903';
one8_name[2]='珠海市';
one8_val[3]='0904';
one8_name[3]='汕头市';
one8_val[4]='0905';
one8_name[4]='韶关市';
one8_val[5]='0906';
one8_name[5]='河源市';
one8_val[6]='0907';
one8_name[6]='梅州市';
one8_val[7]='0908';
one8_name[7]='惠州市';
one8_val[8]='0909';
one8_name[8]='汕尾市';
one8_val[9]='0910';
one8_name[9]='东莞市';
one8_val[10]='0911';
one8_name[10]='中山市';
one8_val[11]='0912';
one8_name[11]='江门市';
one8_val[12]='0913';
one8_name[12]='佛山市';
one8_val[13]='0914';
one8_name[13]='阳江市';
one8_val[14]='0915';
one8_name[14]='湛江市';
one8_val[15]='0916';
one8_name[15]='茂名市';
one8_val[16]='0917';
one8_name[16]='肇庆市';
one8_val[17]='0918';
one8_name[17]='云浮市';
one8_val[18]='0919';
one8_name[18]='清远市';
one8_val[19]='0920';
one8_name[19]='潮州市';
one8_val[20]='0921';
one8_name[20]='揭阳市';
var selected_id;
var name_arry;
var value_array;
if(selone != 'null')
{
selected_id = selone - 1;
name_array='one' + selected_id + '_name';
value_array='one' + selected_id + '_val';
var array_length=eval(name_array).length; document.frmreg.city.options[0]=new Option("--请选择--","");
for (var i=0; i < array_length ; i++)
{
document.frmreg.city.options[i]=new Option(eval(name_array)[i],eval(value_array)[i]);
if(seltwo == eval(value_array)[i])
{
document.frmreg.province.options[selone].selected = true;
document.frmreg.city.options[i].selected = true;
}
}
}
else
{
selected_id=document.frmreg.province.selectedIndex;
selected_id--;
if(selected_id < 0) selected_id = 0;
name_array='one' + selected_id + '_name';
value_array='one' + selected_id + '_val';
var array_length=eval(name_array).length; document.frmreg.city.length=0; if (array_length==0)
{
document.frmreg.city.options[0]=new Option("该省没有市","");
}
else
{
document.frmreg.city.options[0]=new Option("--请选择--","");
for (var i=0; i < array_length ; i++)
{
document.frmreg.city.options[i+1]=new Option(eval(name_array)[i],eval(value_array)[i]);
}
}
document.frmreg.city.selectedIndex = 0;
}
} <select class=input
onChange="javascript:chg_SelTwo('null','null');"
name=province>
<option value="" selected>--请选择--</option>
<option value=0008>江苏省</option>
<option value=0009>广东省</option>
</select>