 |
| Google Duo |
 |
| Jquery ajax database username checker |
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),
);
<!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>
$(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>');
}
});
});
//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";
}
<!--author comment highlight-->
<script type="text/javascript"> $(function() { function highlight(){ $('.user.blog-author,.ssyby').closest('.comment-block') .css('border', '1px solid #e1e1e1') .css('background','#f1f1f1 url("https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIHGSaDTMLkfvdP-e7b7nDXbM8K7w3FfXvZqMr5LveG19UVfptubbPPdc9IGKaiquqLm4JWS7bmNJnI3nO2bNfcoJBt5Fu670032g7hxjKKECV9uAsvKEqk0plF6vpIXZpGn4hT4dkvIS-/w140-h126-p/admin-comment-button.png") no-repeat bottom right') .css('padding', '10px'); } $(document).bind('ready scroll click', highlight); });</script><a style="display:none" href="http://allblogsolution.blogspot.com"> Widgets</a>
<!--author comment highlight-->
