在网上找了好多代码,就下面这个感觉比较靠普,可是调试的时候发现只有第一个下拉框可以载入数据,第二个下拉框无法载入数据,请高手帮忙看一下问题出在哪里,这个问题困扰我好几天了,先谢谢了.test.php
<html>
<head><title>php_ajax联动下拉菜单</title>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
<script language="javascript" src="ajax.js"></script>
<script language="javascript">
function query(){
var pid = document.getElementById("bigClassName").value;
if(pid!=""){
createRequest('query.php?pid='+pid);
}
}
</script>
</head><body>
<form action="<?=$PHP_SELF?>?" name="class" method="get" >
<select name="bigClassName" id="bigClassName" onChange="query()">
<option value="">--选择大类--</option>
<?php
$link=mysql_connect("localhost","root","12341234");
mysql_select_db("mydb") or die("没有此数据库!");
$sql="select* from myteam";
mysql_query("set names gb2312");
$res=mysql_query($sql,$link);
while($result=mysql_fetch_assoc($res)){
echo "<option value='".$result["my_team_title"]."'>".$result["my_team_title"]."</option>";
}
?>
</select>
<select name="smallClassName" id="smallClassName">
<option value="">--选择小类--</option>
</select>
<input type="submit" value="提交" />
</form>
</body>
</html>query.php
<?php
error_reporting(E_ERROR|E_WARNING|E_PARSE);
$link=mysql_connect("localhost","root","12341234");
mysql_select_db("mydb",$link) or die("no such database!");
//$GB2312string=iconv( 'UTF-8', 'gb2312//IGNORE' , $RequestAjaxString); //Ajax中先用encodeURIComponent对要提交的中文进行编码
mysql_query("set names gb2312");
$pid=$_GET[pid];
$res=mysql_query("select * from my_user where my_user_team='$pid'",$link);
header('Content-type: text/html;charset=GB2312'); //指定发送数据的编码格式为GB2312
while($info=mysql_fetch_array($res)){
$str.=$info["my_display_name"].",".$info["my_display_name"];
$str.=";";
}
echo $str;
?>ajax.js
var http_request = false;
function createRequest(url) {
//初始化对象并发出XMLHttpRequest请求
http_request = false;
if (window.XMLHttpRequest) { //Mozilla等其他浏览器
http_request = new XMLHttpRequest();
if (http_request.overrideMimeType) {
http_request.overrideMimeType("text/xml");
}
} else if (window.ActiveXObject) { //IE浏览器
try {
http_request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
http_request = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {}
}
}
if (!http_request) {
alert("不能创建XMLHTTP实例!");
return false;
}
http_request.onreadystatechange = alertContents; //指定响应方法http_request.open("GET", url, true); //发出HTTP请求
http_request.send(null);
}
function alertContents() { //处理服务器返回的信息
if (http_request.readyState == 4) {
if (http_request.status == 200) {
var smallClassName=document.getElementById("smallClassName");
var dataArray=[]; //alert(http_request.responseText);
myVariable=http_request.responseText;//形如: 1,新闻中心;2,学习园地;
var stringArray = myVariable.split(";");//以;分隔字符串
stringArray.pop();//移除数组最后一个元素,stringArray[0]==1,新闻中心 stringArray[1]==2,学习园地
var len=stringArray.length;
for(var i=0;i<len;i++){
dataArray[i]= stringArray[i].split(",");// 循环数据条数按,分割字符串
}
//alert(dataArray[1][0]);//返回 新闻中心
//初始化smallClassName的数据
smallClassName.length=0;
var alertOption=document.createElement_x("OPTION");
alertOption.value="";
alertOption.text="--选择小类--";
smallClassName.add(alertOption);
for(var j=0;j<len;j++){//添加数据
var objOption=document.createElement_x("OPTION");
objOption.value = dataArray[j][0];
objOption.text = dataArray[j][1];
smallClassName.add(objOption);
}
} else {
alert('您请求的页面发现错误');
}
}
}
<html>
<head><title>php_ajax联动下拉菜单</title>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
<script language="javascript" src="ajax.js"></script>
<script language="javascript">
function query(){
var pid = document.getElementById("bigClassName").value;
if(pid!=""){
createRequest('query.php?pid='+pid);
}
}
</script>
</head><body>
<form action="<?=$PHP_SELF?>?" name="class" method="get" >
<select name="bigClassName" id="bigClassName" onChange="query()">
<option value="">--选择大类--</option>
<?php
$link=mysql_connect("localhost","root","12341234");
mysql_select_db("mydb") or die("没有此数据库!");
$sql="select* from myteam";
mysql_query("set names gb2312");
$res=mysql_query($sql,$link);
while($result=mysql_fetch_assoc($res)){
echo "<option value='".$result["my_team_title"]."'>".$result["my_team_title"]."</option>";
}
?>
</select>
<select name="smallClassName" id="smallClassName">
<option value="">--选择小类--</option>
</select>
<input type="submit" value="提交" />
</form>
</body>
</html>query.php
<?php
error_reporting(E_ERROR|E_WARNING|E_PARSE);
$link=mysql_connect("localhost","root","12341234");
mysql_select_db("mydb",$link) or die("no such database!");
//$GB2312string=iconv( 'UTF-8', 'gb2312//IGNORE' , $RequestAjaxString); //Ajax中先用encodeURIComponent对要提交的中文进行编码
mysql_query("set names gb2312");
$pid=$_GET[pid];
$res=mysql_query("select * from my_user where my_user_team='$pid'",$link);
header('Content-type: text/html;charset=GB2312'); //指定发送数据的编码格式为GB2312
while($info=mysql_fetch_array($res)){
$str.=$info["my_display_name"].",".$info["my_display_name"];
$str.=";";
}
echo $str;
?>ajax.js
var http_request = false;
function createRequest(url) {
//初始化对象并发出XMLHttpRequest请求
http_request = false;
if (window.XMLHttpRequest) { //Mozilla等其他浏览器
http_request = new XMLHttpRequest();
if (http_request.overrideMimeType) {
http_request.overrideMimeType("text/xml");
}
} else if (window.ActiveXObject) { //IE浏览器
try {
http_request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
http_request = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {}
}
}
if (!http_request) {
alert("不能创建XMLHTTP实例!");
return false;
}
http_request.onreadystatechange = alertContents; //指定响应方法http_request.open("GET", url, true); //发出HTTP请求
http_request.send(null);
}
function alertContents() { //处理服务器返回的信息
if (http_request.readyState == 4) {
if (http_request.status == 200) {
var smallClassName=document.getElementById("smallClassName");
var dataArray=[]; //alert(http_request.responseText);
myVariable=http_request.responseText;//形如: 1,新闻中心;2,学习园地;
var stringArray = myVariable.split(";");//以;分隔字符串
stringArray.pop();//移除数组最后一个元素,stringArray[0]==1,新闻中心 stringArray[1]==2,学习园地
var len=stringArray.length;
for(var i=0;i<len;i++){
dataArray[i]= stringArray[i].split(",");// 循环数据条数按,分割字符串
}
//alert(dataArray[1][0]);//返回 新闻中心
//初始化smallClassName的数据
smallClassName.length=0;
var alertOption=document.createElement_x("OPTION");
alertOption.value="";
alertOption.text="--选择小类--";
smallClassName.add(alertOption);
for(var j=0;j<len;j++){//添加数据
var objOption=document.createElement_x("OPTION");
objOption.value = dataArray[j][0];
objOption.text = dataArray[j][1];
smallClassName.add(objOption);
}
} else {
alert('您请求的页面发现错误');
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货