$host="192.168.0.22";
$user="root";
$pwd="123456";
$database="edu_brochure";
$conn=mysql_connect($host,$user,$pwd) or die ("无法连接到数据库服务器,请联系我们".mysql_error());
$db=mysql_select_db($database,$conn) or die ("无法连接到数据库,请联系我们".mysql_error());
$co=$_REQUEST['collegetype'];
//$co="10";
$selectcollegeenamestr="select distinct(collegename) from college where collegetype=(select collegetype from college where collegeid='".$co."'".")";
//echo $selectcollegeenamestr;
$result=mysql_query($selectcollegeenamestr,$conn);
$num = mysql_num_rows($result);
//echo $num;
$arraycollegename=array();
while($row=mysql_fetch_array($result))
{
array_push($arraycollegename,$row[0]);
}
while(List($key,$value)=each($arraycollegename))
{
$charstr.=$value."|";
}
//echo $charstr;
?>
function processRequest(){
if(http_request.readyState==4){
if(http_request.status==200){
var response = request.responseText.split("|");
alert(response);
var num = response[0];
while(var i = 0;i<=num+1;i++)
{
document.getElementbyid("providers").innerHTML=response[1];
}
$host="192.168.0.22";
$user="root";
$pwd="123456";
$database="edu_brochure";
$conn=mysql_connect($host,$user,$pwd) or die ("无法连接到数据库服务器,请联系我们".mysql_error());
$db=mysql_select_db($database,$conn) or die ("无法连接到数据库,请联系我们".mysql_error());
$co=$_REQUEST['collegetype'];
//$co="1";
$selectcollegeenamestr="select collegename from college where collegetype=(select collegetype from college where collegeid='".$co."'".")";
//echo $selectcollegeenamestr;
$result=mysql_query($selectcollegeenamestr,$conn);
$arraycollegename=Array();
while($row=mysql_fetch_array($result))
{
array_push($arraycollegename,$row[0]);
}
while(List($key,$value)=each($arraycollegename))
{
//echo "$key:$value<br>";
$charstr.=$value."|";