Ajax + PHP + Jquery onblur

A.php
<script> 
  $(document).ready(function(){
//檢查帳號是否存在
$('#username').blur(function(){
var acc = document.getElementById("username").value;
$.ajax({url: '../db_select/db_member.php?acc='+acc, type: 'GET'})
  .done(function(response){
var msg = response; //因型態問題，須設置在變數中
if(msg == "no"){ //帳號不存在
$('#username').css({
'color' : '#F00'
});
$('#username').val('無此帳號!');
}
  });
});
});
</script>
<input name="username" type="text" id="username" />


db_member.php

$acc = "-1";
if (isset($_GET['acc']) && $_GET['acc'] != "") {
  $acc = (get_magic_quotes_gpc()) ? $_GET['acc'] : addslashes($_GET['acc']);
}
mysql_select_db($database_labor, $labor);
$sql = sprintf("SELECT acc FROM memberWHERE acc= '%s'", $acc);
$result = mysql_query($sql, $labor);
$row = mysql_fetch_assoc($result);
$total = mysql_num_rows($result);

if($total > 0){
echo "yes";
}else{
echo "no";
}

此時db_member.php就會回傳到A.php接收



參考資料:
http://stackoverflow.com/questions/12384166/send-ajax-request-when-textfields-onblur-event-is-fired

http://stackoverflow.com/questions/10886782/ajax-checking-username-onblur