php 判断用户唯一性,AJAX 用户唯一性验证实现代码

从数据库my中的username用户表里验证：

checkusername.html：

无标题文档

var xmlHttp;

function createXMLHttpRequest(){

if(window.ActiveXObject){

xmlHttp = new ActiveXObject("microsoft.XMLHTTP");

}

else if(window.XMLHttpRequest){

xmlHttp = new XMLHttpRequest();

}

}

function send_request(url,data){

createXMLHttpRequest();

xmlHttp.open("POST",url,true);

xmlHttp.onreadystatechange = check_lll;

xmlHttp.setRequestHeader("CONTENT-TYPE", "application/x-www-form-urlencoded");

xmlHttp.send("username=" + data);

}

function check_lll(){

if(xmlHttp.readyState == 4){

if(xmlHttp.status == 200){

alert(xmlHttp.responseText);

}

}

}

function check_username(){

var f = document.form1;

var username = f.username.value;

if(username == ""){

alert("NULL");

return false;

}

else{

send_request("check_it.php",username);

}

}

姓名：

check_it.php：

$username = $_POST["username"];

$conn = mysql_connect("localhost:3306","root","123");

mysql_select_db("my",$conn);

$sql = "select * from username where username = '$username'";

$result = mysql_query($sql,$conn);

$num = mysql_fetch_array($result);

if($num > 0){

printf("can't use");

}

else{

printf("It can use");

}

?>