下面是唠叨的例子与服务器交互的写法 <?php $conn = mysql_connect(); // 连接数据库 mysql_select_db("test"); // 选择库if(!isset($_GET['key'])) { // 检查是否有传递参数 $sql = "select * from list where type=''"; $rs = mysql_query($sql); $str = ""; while($row = mysql_fetch_array($rs)) // 循环构造初始信息 $str .= "<option value='{$row['name']}'>{$row['name']}\n"; }else { // 有,产生脚本代码 $sql = "select * from list where type='{$_GET['key']}'"; $rs = mysql_query($sql); $str = "sele2.options.length = 0;\n"; while($row = mysql_fetch_array($rs)) $str .= "sele2.options[sele2.options.length] = new Option('{$row['name']}',{$row['name']});\n"; echo $str; exit; } ?> 本方法通过改变script标记的src属性来达到动态修改列表框的内容<br/> <script id="sensele" src=""></script> <script> function loadsele(v) { var s = v.options[v.selectedIndex].value; sensele.src = "?key="+s; } </script> <select id="sele1" onchange="loadsele(this)"> <?php echo $str; ?> </select> <select id="sele2"> </select> <span id="view"></span>表结构 CREATE TABLE list ( type varchar(10) NOT NULL default '', name varchar(50) NOT NULL default '' ) TYPE=MyISAM;# # 导出下面的数据库内容 `list` #INSERT INTO list VALUES ('', 'A'); INSERT INTO list VALUES ('', 'B'); INSERT INTO list VALUES ('', 'C'); INSERT INTO list VALUES ('A', '1'); INSERT INTO list VALUES ('A', '2'); INSERT INTO list VALUES ('A', '3'); INSERT INTO list VALUES ('B', '4'); INSERT INTO list VALUES ('B', '5'); INSERT INTO list VALUES ('B', '6'); INSERT INTO list VALUES ('C', '7'); INSERT INTO list VALUES ('C', '8'); INSERT INTO list VALUES ('C', '9');
<?php
$conn = mysql_connect(); // 连接数据库
mysql_select_db("test"); // 选择库if(!isset($_GET['key'])) { // 检查是否有传递参数
$sql = "select * from list where type=''";
$rs = mysql_query($sql);
$str = "";
while($row = mysql_fetch_array($rs)) // 循环构造初始信息
$str .= "<option value='{$row['name']}'>{$row['name']}\n";
}else { // 有,产生脚本代码
$sql = "select * from list where type='{$_GET['key']}'";
$rs = mysql_query($sql);
$str = "sele2.options.length = 0;\n";
while($row = mysql_fetch_array($rs))
$str .= "sele2.options[sele2.options.length] = new Option('{$row['name']}',{$row['name']});\n";
echo $str;
exit;
}
?>
本方法通过改变script标记的src属性来达到动态修改列表框的内容<br/>
<script id="sensele" src=""></script>
<script>
function loadsele(v) {
var s = v.options[v.selectedIndex].value;
sensele.src = "?key="+s;
}
</script>
<select id="sele1" onchange="loadsele(this)">
<?php echo $str; ?>
</select>
<select id="sele2">
</select>
<span id="view"></span>表结构
CREATE TABLE list (
type varchar(10) NOT NULL default '',
name varchar(50) NOT NULL default ''
) TYPE=MyISAM;#
# 导出下面的数据库内容 `list`
#INSERT INTO list VALUES ('', 'A');
INSERT INTO list VALUES ('', 'B');
INSERT INTO list VALUES ('', 'C');
INSERT INTO list VALUES ('A', '1');
INSERT INTO list VALUES ('A', '2');
INSERT INTO list VALUES ('A', '3');
INSERT INTO list VALUES ('B', '4');
INSERT INTO list VALUES ('B', '5');
INSERT INTO list VALUES ('B', '6');
INSERT INTO list VALUES ('C', '7');
INSERT INTO list VALUES ('C', '8');
INSERT INTO list VALUES ('C', '9');