php原生态三级联动_php实现三级联动

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;

}

}

}

}

省

市

县

<?php mysql_connect('localhost','root','123'); mysql_select_db("news"); 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 "$row[0]"; } }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 "$row[0]"; } }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 "$row[0]"; } }