【導讀】本文用 Ajax 實作一個實用功能:在註冊或購物車結帳時,使用者只需填入郵遞區號,系統便依此自動從資料庫取出對應的省、市等地址資訊。
描述:在註冊或購物車結帳時,需要使用者填寫個人資料。這個環節可以精簡一下——只需使用者填入郵遞區號,再依此自動從資料庫取出相應的省、市等地址資訊。這樣既能減少客戶的輸入、提升使用體驗,又能減少因人工輸入而產生的錯誤。
<script>
function createRequestObject() {
var ro;
var browser = navigator.appName;
if (browser == "Microsoft Internet Explorer") {
ro = new ActiveXObject("Microsoft.XMLHTTP");
} else {
ro = new XMLHttpRequest();
}
return ro;
}
var http = createRequestObject();
function sndReq(zip) {
http.open('get', 'zipcode.php?zip=' + zip);
http.onreadystatechange = handleResponse;
http.send(null);
}
function handleResponse() {
if (http.readyState == 4) {
var response = http.responseText;
var update = new Array();
if (response.indexOf('|') != -1) {
update = response.split('|');
document.getElementById("city").value = update[0];
document.getElementById("state").value = update[1];
}
}
}
</script>
<h3>Enter A United States Zipcode, Then Tab</h3>
<table align="center">
<tr>
<td>Enter Zipcode:</td>
<td><input type="text" id="zipcode" name="zipcode"
onBlur="sndReq(this.value);" /></td>
</tr>
<tr>
<td>City:</td>
<td><input type="text" id="city" name="city" /></td>
</tr>
<tr>
<td>State:</td>
<td><input type="text" id="state" name="state" /></td>
</tr>
</table>
<?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);
?>
當客戶輸入了郵遞區號後,zipcode.php 便接收到它,接著從資料表中取出對應資料,並按一定格式(此處以 | 分隔)回傳給客戶端。最後客戶端接收回傳的資料,顯示在頁面上:
if (response.indexOf('|') != -1) {
update = response.split('|');
document.getElementById("city").value = update[0];
document.getElementById("state").value = update[1];
}