Tutorial - User Registration System

Tutorial - User Registration System

In this tutorial we will show you how to setup User Registration System in ASPMaker. We will use the demo database for demonstration. The demo database is a modified version of the Access demo database Northwind.mdb for better illustration.

We want to set up the "Employees" table for Registration System.

Fields in the User Table, "Employees":

Steps to Setup Registration System

1. Loading ASPMaker

Open ASPMaker and connect to the demo.mdb database.

2. Enabling Security and Setting up User Table

Advanced Security has to be enabled first. Click the [Security] tab, check [User Existing Table], select the [Table], the [Login Name Field] and the [Password Field]. The [Advanced] button will be enabled.

3. Setting up Registration System

Click the [Advanced] button, the Advanced Security window will appear. Click [User Login Options] node in the left pane.

We use the following options:

User Registration Page	Generate user registration page and add a link in login page. Enabled - Enable registration page CAPTCHA - Optionally use CAPTCHA for registraion form Confirm before submit - Optionally let user view the input before submitting the registraion form Send email - Optionally send email confirmation after registration Requires activation - Optionally requires user click an activation link in the email sent after registration to activate the user account. (Send email is required.)
Change Password Page	Generate change password page Send email - Optional email confirmation after changing password
Password Recovery Page	Generate password recovery page (forgot password page) and add a link in login page. User name and password will be sent to the user's email address.
User Email Address Field	User Email Address Field in user table used for sending email
User Activated Field	User Activated Field in user table used for storing the status of user. A boolean field is recommended, although an integer field or a string field will also work. Note: To enable user account activation, the Requires activation and Send email options under User Registration Page must be checked. The user needs to click an activation link in the email sent after registration to activate the user account.

See Security Settings for complete description of the options.

For user registration page, you can select which fields to be included in the page. Click the [...] button in the [Fields] row.

Click [>] to select the field or [>>] to select all fields to be included in registration page. Note that the password field is mandatory. Since we have chosen options that will send emails, the Email field must be included also.

If you use User Level Security also, you should not include the User Level field because a new user is not supposed to choose his/her own User Level. If the User Level field is not included, the default User Level for new user will be 0 (Anonymous). You can assign a suitable User Level to the user later by logging in as an administrator. Alternatively, you can also set a default value for the User Level field in your database or in ASPMaker. Then the new user will get the default User Level immediately after registration.

Click [OK] to finish.

Note: If you have enabled any of the email sending features, you must enter the SMTP server information in the [ASP]->[Email Settings] tab:

See Email Settings in ASP Setup for details.

4. ASP Script Generation

Click the [Generate] button and ASPMaker will generate the required ASP scripts automatically.

5. Running the ASP Application

Run the generated scripts. In login page, the "Register" link and "Forgot Password" link are displayed.

Click the "Register" link, you will be redirected to the registration page. Note that a "Confirm Password" field and JavaScript validation are added automatically.

Click the "Forget Password" link, you will be redirected to the request password page.

If the email address entered by the user can be found in the user table, the password will be sent to the email address.

After login, a "Change Password" link is added in the menu before "Logout". Click it and you'll be redirect to the change password page.

The contents of the email contents can also be modified in the template. The files are register.txt, changepwd.txt and forgotpwd.txt.

For example, the forgot password email content template (forgotpwd.txt) is like the follows. The format is self-explanatory.

Subject: Password Request
From: 
To: 
Cc:
Bcc:
Format: TEXT

Dear Sir/Madam,

Please see below for the requested information:

User Name: 
Password: 

Please feel free to contact us in case of further queries.

Best Regards,
Support

The following special tags are used in the email templates:

is sender email address
 is user email address
 is user login name (for forgotpwd.txt only)
 is user password (for forgotpwd.txt and changepwd.txt only)
 (without the $ symbol) is the field value. (for register.txt only) e.g.  is the field value of the field "LastName".

As for the email format, you can use either "TEXT" or "HTML". If you use HTML, change the line "Format: TEXT" to "Format: HTML" and enter HTML content below it.

You can dynamically change the email by code using Email_Sending event before the email is sent. (See Server Events and Client Scripts)