The Plan
Here is the plan of attack to
validate members -
-
The person signs up and their
info is added to the database, however their account is marked as 'not
validated' and cannot log-in until it is 'validated'.
-
An email is sent to them with a
link that contains their email and an activation code.
-
They click on this link and are
transported to a page
-
The page takes those two values
and looks them up in the database to mark their account as 'validated'
The database will look something
like this -
Table Name :
Users |
ID |
Username |
Password |
Email |
Status |
Primary Key, Auto Number |
Must be unique. Text |
Text |
Must be unique, text |
Text, either V (validated) or
N (not validated) |
The form -
Form Name :
NewUser |
UN |
PWD |
EM |
Username field. |
Password field. |
Email field. |