Insert New User

Create a form that matches the DB table fields

Each insert form must match the db table fields designed in your database. You can limit it to just the info you wish to take from the user. However, the author must consider NOT NULL fields, and what to place in those field by default if not user supplied. The following steps will be considered in this lesson:

1. Insert record into DB table
2. Check against username to make sure that no duplicate accounts exists
3. Validate fields using javaScript
4. Validate submitted form using PHP and analyzing Dreamweaver's WYSIWYG insert

First Name
Last Name
Username (email)
Password
Confirm Password

Paste your completed code in WYSIWYG mode here.

Current Users Table

Create a standard select all on the users table to keep tabs on its development.

UserID	Username	Firstname	Lastname	Password	userIMG
7	ruby@rubyd.net	Ruby	Davily	*AA401FAAD43938E4E4AF20DA7D5F9	Default.jpg
6	sharky@ocean.com	shark	bait	ocean	Default.jpg
5	punkrocker23@yahoo.com	Jesse	James	password	Default.jpg
4	Mitch@mac.com	Mitchell	Gohman	*2470C0C06DEE42FD1618BB99005AD
3	BlueMatt@yahoo.com	Matt	Hunt	*2470C0C06DEE42FD1618BB99005AD
2	caesar@vargas.com	Caesar	Vargas	*2470C0C06DEE42FD1618BB99005AD
1	Justj02@aol.com	Jesse	Jimenez	*2470C0C06DEE42FD1618BB99005AD