PHP+js+ajax,用于两个下拉之间切换数据

chuting1 2016-06-02 11:12:00

数据库表中

szarea oper
081 aaa
082 bbb
081 aaa1
081 aaa2
082 bbb1

程序要求选择081或082，显示在区域中，后面的oper随之变化，用AJAX+JS+PHP

我的代码如下：
login.php
<html>
<head>
</head>
<body bgcolor="#935612" background="0.jpg">

<table width="1000" align="center" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="500" colspan="2"><?PHP echo($Errmsg); ?></td>
</tr>
<form id="form1" name="form1" method="POST" action="<?PHP $_SERVER['PHP_SELF'] ?>" onsubmit="return CheckForm();">
<tr>
<td width="80">所在区域:</td>
<td width="417">
<script charset="gb2312" type="text/javascript" src="oper.js"></script>



<SELECT NAME="szarea" onChange="overnm(this.value)">
<?php
require "conf.php";
$connection=mysql_connect($host,$user,$pass) or die("unable to connect!");
mysql_select_db($db) or die("unable to select database ");
$query1="select distinct szarea from operatorinfo order by szarea";
$result=mysql_query($query1) or die("error sql to exec0");
if (mysql_num_rows($result)>0 )
{
while ( $row=mysql_fetch_row($result))
{
echo "<option value='" . $row[0] . "'>" . $row[0] . "</option>";
}
}
else
{
echo "no rows found !";
}
mysql_free_result($result);
?>
</SELECT>
</td>
</tr>
<tr>
<td width="80">用户名:</td>
<td width="417">
<SELECT NAME="usernm">

</SELECT>
</td>
</tr>
<tr>
<td>密码:</td>
<td><input type="password" name="userpwd"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value=" 登录 ">
<input type="hidden" name="chkpw" value="send">
<input type="button" name="Submit2" value=" 关闭 " onclick="self.close()"></td>
</tr>
</form>

</table>
</HTML>

OPER.js
var xmlHttp

function overnm(str)
{
if (str.length==0)
{
document.getElementById("szarea").innerHTML=""
return
}
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="getoper.php"
url=url+"?q="+str
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("usernm").innerHTML=xmlHttp.responseText //responseXML responseText
}
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}

getoper.php

<?php
header('Content-Type:text/html;charset=GB2312');
$q=$_GET["q"];
//echo $q;
require "conf.php";
$connection=mysql_connect($host,$user,$pass) or die("unable to connect!");
mysql_select_db($db) or die("unable to select database ");

$query1="select adminname from operatorinfo where szarea='" . $q . "' order by id";
//echo $query1;
$result=mysql_query($query1) or die("error sql to exec2");
if (mysql_num_rows($result)>0 )
{
$operlist = array();
$i=0;
echo "<select id='usernm'>";
echo "<script type='text/javascript'>";
echo "var usernm = document.getElementById ('usernm');";

while ( $row=mysql_fetch_row($result))
{

echo " var opt = document.createElement ('option' );";
echo " opt.value = '" . $row[0] . "';";
echo " opt.innerText = '" . $row[0] . "';";
echo " usernm.appendChild (opt);";
}
echo "</script>";
echo "</select>";

}

mysql_free_result($result);
?>

getoper.php?q=081可以直接输出下拉列表，但login.php就不可以，提示oper.js 28行错误

...全文