Skip to main content

Username Availability Check Using Jquery, PHP, Mysql, Ajax

When We try to Register for any website and On the Username Field We just type your desired Username and within Seconds Without Refreshing the Page the system Checks if the username Is Available or Not so today's my tutorial is based on the same functionality.
we have Following 4 Files in our Directory And Each file is going to perform its own function.

  1.  Index.php
  2. user.js 
  3. db.php
  4. username_check.php

    Following Function Will Be Performed When Our Username is being Checked

Download

  1. Username is fetched from index.php and send to the server for checking.
  2. if the username is taken then an error message will be shown
  3. else there will be a available message.
so lets start

First we have To create a index file. I am not using any stylesheet for this. its just an simple form without any formatting or styling.

so here is the code for index.php file


<!doctype html>
<html lang="en">
<head>
 <meta charset="utf-8">
 <title> Jquery Username Check Tutorial</title>
</head>
<body>
 <input id="username" type="text" /><span id="username_status"></span>
 
 <script type="text/javascript" src="js/jquery.js"></script>
 <script type="text/javascript" src="js/users.js"></script>
</body>
</html>

So it will show just an text field and and a span is there with an id "username_status" this span is for showing the status message.

Now lets write the user.js code. The jquery code is written below. This code will fetch the data from the index.php and send it to username_check.php and then will print the result to the page.


$('#username').keyup(function(){
var username = $(this).val();
$('#username_status').text('searching....');
if(username != '') {
$.post('username.php',{ username:username },function(data){
 $('#username_status').text(data);
});
}
else {
 $('#username_status').text('Nothing');
}
});

Now we here comes the username_check.php file which will perform the main functionality of this application.

<?php
if(isset($_POST['username']))
 {
  $username = mysql_real_escape_string($_POST['username']);
  echo $username;
 if(!empty($username))
   {
   $username_query = mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `username` = '$username'");
   $username_result = mysql_result($username_query,0);
    if($username_result == 0)
     {
      echo 'Username available!';
     } else ($username_result ==1) {
      echo 'Sorry, That username is Taken!';
     }
    }
  ?>


And your are Done This will do everything you just have to make a database connection and this will start its working.

You can download whole script from the download link
Labels:

Comments

Post a Comment

your Comment is sent for moderation, Thankyou

Popular posts from this blog

Network Topologies (Tutorial-4)

Topology refers to the way in which the network of computers is connected. The choice of topology is dependent upon--- Type and number of equipment being used  Planned applications and rate of data transfers  Required response times  Cost Types of Network Topologies Physical Topology: Physical topology defines how devices are connected to the network through the actual cables that transmit data(physical structure of the network)  Logical Topology: Logical Topology (also referred to as Signal Topology) is a network computing term used to describe the arrangement of devices on a network and how they communicate with one another.
Post a Comment
Read more

Networking (Tutorial-8) IEEE Standards

IEEE INTRODUCTION Institute of Electrical And Electronics professional organization for the advancement of technology related to electricity.  Formed in 1963 by the merger of IRE( Institute of Radio Engineers ) and AIEE(American Institute of Electrical Engineering)  IEEE is one of the leading standards-making organizations in the world. IEEE performs its standards making and maintaining functions through the IEEE Standards Association(IEEE-SA).  IEEE Standards The Institute of Electrical and Electronics Engineers Standards Association (IEEE-SA) is a leading developer of global industry standards in a broad-range of industries, including:  Power and Energy  Biomedical and Healthcare  Information Technology  Telecommunications  Transportation  Nanotechnology  Information Assurance  Development of IEEE Standards The IEEE standards development process can be broken down into seven basic steps, as follows: ...
Post a Comment
Read more

Cisco Hierarchical Model

Cisco Hierarchical Model Defined by Cisco to simplify the design, implementation, and maintenance of responsive, scalable, reliable, and cost-effective networks. The 3 layers are logical and not physical – there may be many devices in a single layer, or a single device may perform the functions of 2 layers, eg: core and distribution. The Cisco Hierarchical Model
Post a Comment
Read more