HomePHP Page 5 - Building an E-Commerce Site Part 2: Managing Users with Sessions
Step 1: Creating the Users Table - PHP
This is the second article in a three-part series dealing with using PHP 4 and MySQL to make a comprehensive e-commerce storefront solution. This article covers session management within the store, user privileges, and a few security concerns.
Start up MySQL and login as the root user by issuing this command from the shell prompt:
$ mysql -u root -p
You should see MySQL started:
Your MySQL connection id is 412 to server version: 3.22.30
Type 'help' for help.
Now select the mymarket database:
mysql> USE mymarket;
Now you're in the mymarket database, let's create the user table:
mysql> CREATE TABLE users (
-> username char(16) not null,
-> password char(32) not null,
-> priv char(5) not null,
-> firstname varchar(64) not null,
-> lastname varchar(64) not null,
-> email varchar(128) not null,
-> phone varchar(32) not null,
-> address varchar(255) not null,
-> PRIMARY KEY (username),
-> UNIQUE email (email)
Notice the constraints we've put on the users table, the username is the primary key (which makes sense, you should be able to identify a user record based on the username). The email address has a unique constraint as well because we don't want duplicate email addresses.
Now let's add a record to create the root user with the password password:
Notice the password looks a bit wierd, 5f4dcc3b5aa765d61d8327deb882cf99. This is the MD5 hash of the the word "password", I won't go into details here, but the important thing to note is that it's a one-way algorithm and it always produces a 32 character string.
That's it, we have a users table to track our users, and one administrative account so we can try logging in and out of the system.