2. The Database

 

The MySQL database (you will need a MySQLi host also this host provides PHP PDO hosting) used for this example has a simple three field table named members.  The SQL query used to create the table is shown below:

CREATE TABLE members (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
password VARCHAR(12) NOT NULL,
username VARCHAR(12) NOT NULL,
index(password),
index(username))

As can be seen above the "id" is the primary key and is auto incremental.  The "username" and "password" fields are both indexed and must have a value to enter a valid record.  Now add a User to this table.