<?
/*
Author:Esnow.xu
msn:esnow@sina.com
qq:7143137
web:www.xujunhui.com
date:2008.10.16
*/
header("Content-Type: text/xml; charset=gb2312");//必须设置，否则浏览器会以html输出，这样前台无法接到xml对象数据
header ("Cache-Control: no-cache, must-revalidate");//每次都是最新
header ("Pragma: no-cache");
//数据库信息
$host = "localhost";
$user = "root";
$pass = "eduask";
mysql_connect($host,$user,$pass);
//接收
$sid=$_GET["sid"];
$type = $_GET["type"];//类型1 城市 2地区 3 区号和邮政编码
//设定为XML文件
echo "<?xml version=\"1.0\" encoding=\"GB2312\"?>";
switch($type){
case 1:
getCitysXMLData($sid);
break;
case 2:
getAreasXMLData($sid);
break;
case 3:
getZipsXMLData($sid);
break;
}
//获取数据，生成XML格式
function getCitysXMLData($sid){
$strCitySql = "select city,cityid from cities WHERE provinceid ='".$sid."'";
$res = mysql_db_query("xmlinfo",$strCitySql);
//输出根标记
echo "<Item>";
while ($myrow = mysql_fetch_array($res)){
echo "<City>";
//输出子元素
echo "<Name>".$myrow["city"]."</Name>";
echo "<ID>".$myrow["cityid"]."</ID>";
echo "</City>";
}
echo "</Item>";
}
function getAreasXMLData($sid){
$sqlSqlArea = "select area,areaid FROM areas WHERE cityid ='".$sid."'";
$res = mysql_db_query("xmlinfo",$sqlSqlArea);
echo "<Item>";
while ($myrow = mysql_fetch_array($res)){
echo "<Area>";
echo "<Name>".$myrow["area"]. "</Name>";
echo "<ID>".$myrow["areaid"]."</ID>";
echo "</Area>";
}
echo "</Item>";
}
function getZipsXMLData($sid){
$sqlSqlZipCode = "select zip,code FROM zipcode WHERE areaid ='".$sid."'";
$res = mysql_db_query("xmlinfo",$sqlSqlZipCode);
echo "<Item>";
while ($myrow = mysql_fetch_array($res)){
echo "<ZipCode>";
echo "<Zip>".$myrow["zip"]."</Zip>";
echo "<Code>".$myrow["code"]."</Code>";
echo "</ZipCode>";
echo "</Item>";
}
}
?>
使用Ajax实现三级级联菜单获取区号与邮政编码 PHP MySQL
5星 · 超过95%的资源 需积分: 9 109 浏览量
2008-10-16
09:07:34
上传
评论 1
收藏 50KB RAR 举报 
getZipInfo.rar （7个子文件） 
getZipInfo data 
Provinces.sql 3KB Areas.sql 256KB Cities.sql 30KB ZipCode.sql 245KB index.php 2KB getData.php 2KB fun.js 3KB
评论2