Part 3: Create your own Registration System using PHP and MySql

3. Creating the Database and setting-up Tables

You can skip this step if you followed the Secure Login System Tutorial.

For this part, you will need to access your MySQL database, either using phpMyAdmin or your preferred MySQL database management application.

If you’re using phpMyAdmin then follow these instructions:

• Navigate to: http://localhost/phpmyadmin/
• Click the Databases tab at the top
• Under Create database, type in phplogin in the text box
• Select utf8_general_ci as the collation
• Click Create

You can use your own database name, but for this tutorial, we’ll use phplogin.

What we need now is an accounts table that will store all our accounts (usernames, passwords, emails, etc).

Click the database on the left side panel (phplogin) and execute the following SQL statement:

CREATE TABLE IF NOT EXISTS `accounts` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
  	`username` varchar(50) NOT NULL,
  	`password` varchar(255) NOT NULL,
  	`email` varchar(100) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

On phpMyAdmin this should look like:

The above SQL statement code will create the accounts table with the columns id, username, password, and email.