php AJAX執行個體根據郵編自動完成地址資訊_PHP教程

Enter A United States Zipcode, Then Tab

Enter Zipcode:
City:
State:

以上是客戶輸入頁面，下面是服務端的處理頁面'zipcode.PHP
$dbuser = 'root';
$dbpass = '111111';
$cn = mysql_connect("localhost", $dbuser, $dbpass);
$db = mysql_select_db("ajax");
$sql = "select city, state from zipcodes where zipcode = " . $_REQUEST['zip'];
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs);
echo $row['city'] . "|" . $row['state'];
mysql_close($cn);
?>
當客戶輸入一個POSTCODE後，zipcode.PHP就接收到它，然後進行從資料表中取出對應的資料，再按一定的格式返回給用戶端（此處是以 | 分隔）。最後用戶端接收返回的資料，顯示在頁面上。
if(response.indexOf('|' != -1)) {
update = response.split('|');
document.getElementById("city").value = update[0];
document.getElementById("state").value = update[1];

http://www.bkjia.com/PHPjc/319751.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/319751.htmlTechArticlescript function createRequestObject() { var ro; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ ro = new ActiveXObject("Microsoft.XMLHTTP"); }else{ ro...

