CODEWITHSUNDEEP
phpjqueryajaxvalidation
Ben McRae
Ben McRae

Reputation: 3531

AJAX live email validation (PHP)

When a user creates an account on my website, I want the input username to be checked against all the current usernames in my database(MySQL) and confirmed if it is available.

Does anyone know any good libraries I could use, or a plug-in for jQuery perhaps?

Upvotes: 1

Views: 4133

Answers (3)

Shane O'Grady
Shane O'Grady

Reputation: 2495

Exactly what you want is given in example form here. it uses jQuery as the JavaScript library

Upvotes: 3

Scott Evernden
Scott Evernden

Reputation: 39926

And this is untested code that is the server-side

<?php
// check_username_available.php?name=(name they supplied)

// this stuff is normally in config.inc.php
$username = "...";  // Mysql username 
$password = "...";  // Mysql password 
$db_name = "...";   // Database name 

// get name supplied from querystring
$name = $_GET('name');

// Connect to server and select database.
//
mysql_connect("localhost", $username, $password) or die("cannot connect to db"); 
mysql_select_db($db_name) or die("cannot select $db_name DB");

$query = "SELECT COUNT(*) FROM 'users' WHERE user_name = '$name'";
$result = mysql_query($query) or die("cannot count rows: " . mysql_error());

header("Content-Type: text/plain");
echo ( 0 < mysql_result($result, 0) ? "false" : "true" );

Upvotes: 2

&#211;lafur Waage
&#211;lafur Waage

Reputation: 69991

Create a PHP file that takes the username as an argument. Then pass it through a $.get method in jquery. This then returns a variable (in my case called data) That variable will contain anything the PHP file printed.

$.get("ajax_available.php?u="+username, function(data){
    if(data == "true")
    {
        // username avaiable
            $("#usernameAlert").html("<img src='images/icons/accept.png' 
               title='Laust' /> Username available");
    }
    else
    {
        // username not avaiable
    }
});

In this example my php file returns the string "true" but thats just a quick example.

Upvotes: 1

Related Questions