PHP ajax XML 获取省份地区邮政编码信息

<? /* 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>"; } } ?>