php jquery check username ajax检察帐号唯一性 _Ajax

php jquery check username ajax检查帐号唯一性

检查email唯一性，当然也方便改为这样注册帐号

演示

?html文件

XML/HTML Code
<input?name="username"?id="username"?type="text"?/>??

js文件

JavaScript Code
<script>??
$(document).ready(function(){??
$('#username').keyup(username_check);??
});??
??????
function?username_check(){????
var?username?=?$('#username').val();??
if(username?==?""?||?username.length?<?4){??
$('#username').css('border',?'3px?#CCC?solid');??
$('#tick').hide();??
}else{??
??
jQuery.ajax({??
???type:?"POST",??
???url:?"check.php",??
???data:?'username='+?username,??
???cache:?false,??
???success:?function(response){??
if(response?==?1){??
????//不可以注册??
????$('#username').css('border',?'3px?#C33?solid');???
????$('#tick').hide();??
????$('#cross').fadeIn();??
????}else{??
????$('#username').css('border',?'3px?#090?solid');??
????$('#cross').hide();??
????$('#tick').fadeIn();??
?????????}??
??
}??
});??
}??
??
??
??
}??
??
</script>??

check.php

PHP Code
<?php??
include("conn.php");??
//??
$username?=?trim(strtolower($_POST['username']));??
$username?=?mysql_escape_string($username);??
??
if?(eregi("^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$",$username))?{???
????//email通过检查??
????$query?=?"SELECT?email?FROM?username_list?WHERE?email?=?'$username'?LIMIT?1";??
????$result?=?mysql_query(?$query?);??
????$num?=?mysql_num_rows($result);??
??????
????echo?$num;??
}???
else??
??
{??
echo?"1";//不能注册??
??
}??
?>??

原文地址:http://www.freejs.net/article_biaodan_35.html