liandong.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'){
$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'){
$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>";
}
}
liandong.html
<html>
<head>
<script>
function san(val,table){
var xhr;
if(window.ActiveXObject){
xhr=new ActiveXObject("Microsoft.XMLHTTP");
}else if(window.XMLHttpRequest){
xhr=new XMLHttpRequest();
}
var url="liandong.php";
xhr.open("POST",url,true);
xhr.onreadystatechange=callback;
xhr.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xhr.send("val="+val+"&table="+table);
function callback(){
if(xhr.readyState==4){
if(xhr.status==200){
document.getElementById(table).innerHTML=xhr.responseText;
}
}
}
}
</script>
</head>
<body οnlοad="san('','t_province')">
<select id="t_province" οnchange="san(this.value,'t_city')">
</select>省
<select id="t_city" οnchange="san(this.value,'t_district')">
</select>市
<select id="t_district">
</select>县
</body>
</html>
315
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
