Checking Username Availability with Mootools and Request.JSON

This tutorial will teach you how to check username availability with Mootools' Request.JSON and PHP/MySQL

In this tutorial you will learn how to use Mootools' Request.JSON function to check a username against an array or database. In this example we will be using a simple MySQL database. I will try to do as much hand holding as I can, but having a little experience with PHP and MySQL will be a plus.

Tutorial Details

• PHP Server and MySQL Database required
• Difficulty: Beginner/Intermediate
• Estimated Completion Time: 30 - 45 Minutes

Step 1 - The Setup

We are going to create a simple database and add a table. After that we will add a username into the database.

CREATE TABLE IF NOT EXISTS ajax_users (
	id INT(2) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	user_name VARCHAR(128) NOT NULL
);
 
INSERT INTO ajax_users VALUES('NULL','matt');