使用Ajax实现（省|市|县）三级联动

发布时间：2020-12-15 21:01:31 所属栏目：百科来源：网络整理

导读：index.html html head meta charset="utf-8" script function getArea(val,table){ var xhr; if(window.ActiveXObject){ xhr = new ActiveXObject("Microsoft.XMLHTTP"); }else if(window.XMLHttpRequest){ xhr = new XMLHttpRequest(); } var url = "ajax.p

index.html

<html>
<head>
<meta charset="utf-8">
<script>
function getArea(val,table){
var xhr;
if(window.ActiveXObject){
xhr = new ActiveXObject("Microsoft.XMLHTTP");
}else if(window.XMLHttpRequest){
xhr = new XMLHttpRequest();
}
var url = "ajax.php";
xhr.open("POST",url,true);
xhr.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xhr.onreadystatechange = callback;
xhr.send("val="+val+"&table="+table);
function callback(){
if(xhr.readyState==4){
if(xhr.status ==200){
//alert(xhr.responseText);
document.getElementById(table).innerHTML = xhr.responseText;
}
}

}
}
</script>
</head>
<body onLoad="getArea('','t_province')">
<select id="t_province" onChange="getArea(this.value,'t_city')"></select>省
<select id="t_city" onChange="getArea(this.value,'t_district')"></select>市
<select id="t_district"></select>县
</body>
</html>

ajax.php

<?php mysql_connect('localhost','root','123'); mysql_select_db('china'); mysql_query("set names utf8"); //获得用户点击的值以及应该显示的表明 $val = $_POST['val']; $table = $_POST['table']; if($table == 't_province'){ //查询所有的省 $sql = "select ProName from $table order by ProSort"; $result = mysql_query($sql); $rows = array(); while($row = mysql_fetch_row($result)){ echo "<option>$row[0]</option>"; } }else if($table =='t_city'){ //已知 ProName 查询对应的市的名字 $sql = "select CityName from t_city where ProID=(select ProID from t_province where ProName = '$val')"; $result = mysql_query($sql); $rows = array(); while($row = mysql_fetch_row($result)){ echo "<option>$row[0]</option>"; } }else if($table =='t_district'){ //已知 CityName 查询对应的县的名字 $sql = "select DisName from t_district where CityID=(select CityID from t_city where CityName = '$val')"; $result = mysql_query($sql); $rows = array(); while($row = mysql_fetch_row($result)){ echo "<option>$row[0]</option>"; } } ?>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!