Most Popular Tutorials
Most Popular Tutorials :-

Simply Easy Learning at Your Fingertips. Click Tutorials Menu to view More Tutorial List





How to User Check Availability using ajax?

Database Table

File Name :

                            CREATE TABLE `freeze`.`user` (
                            `id` INT( 3 ) NOT NULL AUTO_INCREMENT ,
                            `username` VARCHAR( 30 ) NOT NULL ,
                            `password` VARCHAR( 50 ) NOT NULL ,
                            `email` VARCHAR( 50 ) NOT NULL ,
                            PRIMARY KEY ( `id` )

                            ) ENGINE = INNODB;
                                                         

   

                        When submit button is clicked, ajax function will be called with method as POST, url as ajax.php and sucess message.                                                  

File Name : index.php








Username Check using Ajax



Username:









File Name : user_check.php

//include('db.php');

$query=mysql_connect("localhost","root","");
mysql_select_db("ajax",$query);

if(isset($_POST['name']))
{
$name=mysql_real_escape_string($_POST['name']);
$query=mysql_query("select * from users where name='$name'");
$row=mysql_num_rows($query);
if($row==0)
{
echo "Available";
}
else
{
echo "Already exist";
}
}
?>





Previous Next


Trending Tutorials


PHP

PHP

100+ Tutorials
oops

PHP OOPs

80+ Tutorial
Codeigniter

Codeigniter

100+ Tutorial
Laravel

Laravel

100+ Tutorials
Node.js

NODE.JS

100+ Tutorials
Javascript

Javascript

100+ Tutorials


Review & Rating

0.0 / 5

0 Review

5
(0)

4
(0)

3
(0)

2
(0)

1
(0)

Write Review Here


Most Popular Tutorials

 Important Link