我是JQuery的新手,并试图编写一个脚本来检查用户名的可用性.我的问题是无论我输入什么,我总会回来“这个用户名已经被使用了”.
JQuery源码:
$(document).ready(function() {
jQuery.validator.addMethod("usernameCheck", function(username) {
var isSuccess = false;
$.ajax({ url: "username_availability.php",
data: "username=" + username,
async: false,
success:
function(msg) { isSuccess = msg === "TRUE" ? true : false }
});
return isSuccess;
},"");
$("#register_form").validate({
onkeyup:false,
rules: {
username: {
required: true,
minlength: 3,
usernameCheck: true // remote check for duplicate username
}
},
messages: {
username: {
required: "username is required.",
minlength: jQuery.format("username must be at least {0} characters in length."),
usernameCheck: "This username is already in use."
}
}
});
PHP来源:
include('database_connection.php');
if (isset($_POST['username'])) {
$username = mysql_real_escape_string($_POST['username']);
$check_for_username = mysql_query("SELECT user_id FROM users WHERE username='$username'");
if (mysql_num_rows($check_for_username)) {
echo "TRUE";
} else {
echo "FALSE"; //No Record Found - Username is available
}
}
?>
HTML来源:
非常感谢