AJAX HTML Javascript jQuery PHP Example MORE
Need a Website Or Web Application Or Any Help.Contact Us: +91 9437911966 (Whatsapp) Note: Paid Service

Live username availability check in PHP AJAX


Here we using 2 file for Live username availability check in PHP AJAX

  1. index.php
  2. check_availability.php

index.php

<!DOCTYPE HTML>
<html lang="en-US">
<head>
	<meta charset="UTF-8">
	<title></title>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script>
</head>
<body>
<div class="container">
	<div class="row">
		<div id="frmCheckUsername">
			<label>Check Username:</label>
			<input name="username" type="text" id="username" class="demoInputBox" onBlur="checkAvailability()"><span id="user-availability-status"></span>    
		</div>
		<p><img src="loder.gif" id="loaderIcon" style="display:none" /></p>
	</div>
</div>

<script type="text/javascript">
function checkAvailability(){
	$("#loaderIcon").show();
	
	$.ajax({
		type:"POST",
		url:"check_availability.php",
		cache:false,
		data:{
			type:1,
			username:$("#username").val(),
		},
		success:function(data){
			$("#user-availability-status").html(data);
			$("#loaderIcon").hide(1000);
		}
	});
}
</script>
</body>
</html>
  

check_availability.php

<?php
	$con =mysqli_connect('localhost','root','','dp_testing');
	if(!$con){
       die("Failed to connect:" . mysqli_connect_error());
    } 
	if(isset($_POST['type']) == 1){
		$username =$_POST['username'];
		 $query ="SELECT * FROM users where user_name ='".$username."' ";
		$result =mysqli_query($con, $query);
		$rowcount=mysqli_num_rows($result);
		if($rowcount >0){
			echo "<span class='status-not-available'> Username Not Available.</span>";
		}else{
			 echo "<span class='status-available'> Username Available.</span>";
		}
	}
?>