Ajax login validation system in PHP using jQuery

Last time, I’ve showed you how to check user availability in Ajax using jQuery’s fading effect. But I’ve just shown the example without connecting the database and some people have faced problem with database connecting solution of that problem.In this post, I’ll show you how to use Ajax login system in php using jQuery and some animation as well.

View Demo

In this example, first of all we’ll validate the user login detail from ajax showing the messages with some animation. If authenticated, the user will be redirected to the secure page “secure.php”. If you’ll try to directly access “secure.php”, you can’t do that.

Now let’s look at the code how to do this,


< form method="post" action="" id="login_form" />
  < input name="username" type="text" id="username" value="" maxlength="20" />
  < input name="password" type="password" id="password" value="" maxlength="20" />
  < input name="Submit" type="submit" id="submit" value="Login" />
< /form >

As you can see in html code, we’ve created the form with id “login_form”.

And furthermore, the CSS code is same as the one available in the pervious post of checking user availability in ajax and php.

JavaScript Code for Ajax Login validation system in PHP

First of all we need to use the jQuery library in our code,

< script src="jquery.js" type="text/javascript" language="javascript"></script >

Now let’s look at the code in javaScript to call ajax and show the animated message with fading effects.

	//remove all the class add the messagebox classes and start fading
	//check the username exists or not from ajax
	$.post("ajax_login.php",{ user_name:$('#username').val(),password:$('#password').val(),rand:Math.random() } ,function(data)
	  if(data=='yes') //if correct login detail
		$("#msgbox").fadeTo(200,0.1,function()  //start fading the messagebox
 		  //add message and change the class of the box and start fading
		  $(this).html('Logging in.....').addClass('messageboxok').fadeTo(900,1,
  	  	     //redirect to secure page
	  	$("#msgbox").fadeTo(200,0.1,function() //start fading the messagebox
		  //add message and change the class of the box and start fading
		  $(this).html('Your login detail sucks...').addClass('messageboxerror').fadeTo(900,1);
       return false;//not to post the  form physically

As you can see above this code is preety much similar to the previous post of checking username availability in ajax and php and you can see the explanation of the above code from that post. But in above code, where the user is validated, he’ll be logged into the “secure.php” using “document.location” in JavaScript.


Well, as you can see above javaScript’s code, when focus is moved away from the password it also call the for sumit action. Basically whenever you hit tab button in password field, it starts validating the user detail using ajax.

PHP Code for Ajax Login validation system

First of all lets’s look at the code of the “ajax_login.php”.

//get the posted values

//now validating the username and password
$sql="SELECT user_name, password FROM tbl_user WHERE user_name='".$user_name."'";

//if username exists
	//compare the password
		echo "yes";
		//now set the session from here if needed
		echo "no";
	echo "no"; //Invalid Login

As you can see above, the user login detial is validated from the database. If the user login detail doesn’t exists, it just returns the “no” values and if the user login detial does exists the it just return “yes” values with setting username in session variable.

Finally, let’s look at the code of secure.php

//if logout then destroy the session and redirect the user
echo " <a href='secure.php?logout'><b>Logout<b></a> ";
echo " <div align='center'>You Are inside secured Page</a> ";

As you can see above the code of “secure.php” is simpleforward. If the user is not authenticated by session then he’ll be redirected to “index.html”. And there is link for “logout” in this page form where user can destroy the seession.

Download Full Source Code

Implementation Guide:

To implement this code, dump the tbl_user “table” available in the zip file to your database and configure the database connection in “ajax_login.php”.

156 thoughts on “Ajax login validation system in PHP using jQuery

  1. hI, thanks for your article but I’m having the same problem as a few people. The log in won’t work regardless of what I try. I read the comments and tried the trim but that doesn’t solve it either :(

  2. bah, comment system sucks :(.. i just entered a long reply for martin, but spam protection sum was wrong and now i need to rewrite everything.

    I make it short. check your ajax_login.php should only contain “yes” or “no” – NO other output like or no. And check if you connected to sql database/no php errors.

  3. malaspigar

    I don’t know who did this, but God bless you.
    You just solved a big problem. Thank you!

  4. Peter

    Hi Roshan, Great tutorial I am having one small problem though.

    I would like to insert my own username and password into the table but when I do this using the command,

    INSERT INTO `tbl_user` VALUES (1, ‘username’, ‘password’);

    It goes into the table fine but when I try to use the new username and password to log in it won’t let me through.

    Can you help?

    Thanks mate!

Comments are closed.