Username availability checking in database using php with jquery ajax method
![]() |
Jquery ajax database username checker |
Lets follow these core coding of jquery ajax which helps you to check the availability of username or any other data.
First of all you need different 3 codes:
- Database table
- Simple HTML Form with Jquery Ajax method
- PHP coding "check_username.php"
Database Table
Create a table name users in database name test using like following codes:
CREATE TABLE users(
id int(11) not null auto_increment
username varchar(255) UNIQUE KEY,
password varchar(255),
PRIMARY KEY (id),
);
Simple HTML Form
<!doctype html>
<html>
<head>
<script src="<ADD JQUERY LIBRARY URL HERE>"></script>
ADD BELOW SCRIPT HERE OR ADD THE URL
</head>
<body>
<form method="post" name="form" action="check_username.php">
username<input type="text" name="username" id="username"/><br/>
<p id="res"></p>password<input type="password" name="password" id="password" />
<input type="submit" value="submit" name="submit" name="submit"/>
</form>
</body>
</html>
JQUERY AJAX SCRIPT
$(document).ready(function(){
$('#username').keyup(function(){
var uname = $(this).val();
if(uname.length>5)
{
$(#res).html("Processing...");
$.ajax({
type:'post',
url:"check_username.php",
dataType:'text' ,
data:{username:uname}, //key value pairing
success:function(value){
$('#res').html(value);
}
});
}
else{
$('#res').html('<div style="color:red">Needs more than 5 characters</div>');
}
});
});
check_username.php PHP file
//create database connection first
$dbConn = new mysqli("localhost","root","password","test");
//check whether the connection is ready or not
if($dbConn->connect_error)
{
die("Not connected with database, try again");
}
$username = $_POST['username'];
$sqlQuery = "SELECT USERNAME FROM users WHERE username = '$username' ";
$res = $dbConn->query($sqlQuery)
if($res->num_rows>0)
{
echo "Username Already Taken";
}
else{
echo "Username Available. Register Now";
}
thanks for your post.
ReplyDelete