ajax应用-省市联动
两个文件test.php和city.php，运行test.php即可，注意你的数据库配置，sql在附件
test.php代码如下
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ />
<?php
$con=mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“test”,$con);
mysql_query(“set names ‘utf8′”);
$result=mysql_query(“select * from province “,$con);
$province_list=”";
while($query=mysql_fetch_array($result))
{
$province_list.=”<option value=\”$query[id]\”>$query[name]</option>”;
}
?>
<SCRIPT LANGUAGE=”JavaScript” src=”jquery.js”></SCRIPT>
家乡： <select name=”province” id=”province”>
<option value=”0″>请选择</option>
<?=$province_list?>
</select>省
<select name=”city” id=”city”>
<option value=”0″>选择城市</option>
</select>市
<SCRIPT LANGUAGE=”JavaScript”>
$(document).ready(function(){
getcityList();
});
//改变下拉菜单
function getcityList()
{
$(“#province”).change(function(){
$.ajax({
url:”city.php“,
type:”get”,
data:”pid=”+$(this).val(),
//data:”pid=”+$(this).val(),
//data:”&pid=” + $(this).val(),
//{queryString: “”+inputString+”"}
//data:”&user=”+$(“#user”).val()+”&msg=”+$(“#message”).val(),
//data:{user:$(“#user”).val(),msg:$(“#message”).val()},
success:function(data){
$(“#city”).html(data);
}
});
});
}
</SCRIPT>
city.php如下：
<?php
$pid = $_GET['pid'];
$con=mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“test”,$con);
mysql_query(“set names ‘utf8′”);
$result=mysql_query(“select * from city where province_id=$pid”,$con);
$city_list=”";
while($query=mysql_fetch_array($result))
{
$city_list.=”<option value=\”$query[id]\”>$query[name]</option>”;
}
echo ($city_list);
?>
数据库下载