php中的ajax验证,php+ajax验证

index.php

?>

$(document).ready(function () {

$("#name").blur(function () {

var username = $(this).val();

if (username == '') {

$("#availability").html("");

}

else{

$.ajax({

url: "validation.php?name="+$("#name").val()

}).done(function( data ) {

$("#availability").html(data);

});

}

});

});

$db_user = "root";

$db_password = "root";

$db_name = "bbs";

$db_host = "localhost";

//链接数据库

$con = new mysqli($db_host, $db_user, $db_password, $db_name);

//链接失败时打印错误信息

if ($con -> connect_error > 0) {

die('Unable to connect to database [' . $con -> connect_error . ']');

}

//获取参数username的值

$name = $_GET['name'];

//查询数据库，验证用户名是否存在

$query = "Select name FROM members Where name = '$name'";

$result = mysqli_query($con, $query);

//返回结果

if (mysqli_num_rows($result)<1) {

echo "用户名可用";

}

else{

echo "用户名不可用";

}

?>