二级省市mysql_jQuery+php+mysql,轻松实现ajax无刷新省市二级联动

用jQuery的ajax方法,结合PHP,轻松实现省市级的二级联动:

新建area.php

$dbc=mysqli_connect("localhost","xxxx","xxxxxxxxxx","test") or die("can not connect to mysql ".mysqli_error());

mysqli_query($dbc,"set names utf8");

header("Content-Type:text/html;charset=utf-8");

if($_REQUEST['do']=="search" && $_REQUEST['pid']){

$str="";

$str='';

$r="select areaid,name from `china_areas` where parentid='".$_REQUEST['pid']."' order by vieworder asc;";

$q=mysqli_query($dbc,$r);

while(list($areaid,$name)=mysqli_fetch_array($q,MYSQLI_NUM)){

$str.=''.$name.'';

}

$str.='';

echo $str;exit;

}

?>

无刷新二级联动

function down_area(obj){

$.ajax({

type: "POST",

url: "area.php",

data: "do=search&pid="+obj.value,

success: function(msg){

$("#area_list").html(msg);

}

});

}

body{font:12px Arial, "微软雅黑", sans-serif;color:#666;line-height:22px;}

地区:

$r="select areaid,name from `china_areas` where parentid='0' order by vieworder asc;";

$q=mysqli_query($dbc,$r);

while(list($areaid,$name)=mysqli_fetch_array($q,MYSQLI_NUM)){

?>

=$name;?>

}

?>

效果如图：

下拉选择广东省后：