Cookie Based Login System

This tutorial is part of a lengthy discussion on creating a cookie-based login system that will restrict access to specific pages or database records.

Click here to read this article from the beginning

How did we create this login form?

Create the login page

In its most basic form, the login page includes just a simple form that has a Username and Password field. In design view, add a blank line at the top of the page and then insert your form and add the two fields. Be sure to check that the field names match the field names in your registration database. Set the form to post back to this page (cookielogin.asp).

Now, place your cursor on the blank line above the form. You are going to insert a Database Results Wizard here that will check the Username and Password against the values in the database. If there is no matching record, you will see a message telling you to enter them into the login form.

To accomplish this select Insert-Database-Results and choose your Registration database as the database connection in Step 1 and your Registration table in Step 2. In Step 3 click the More Options button and then Criteria. Click the Add button and set the criteria so that Account_Username=Account_Username and Account_Password=Account_Password. .

that checked the username and password against our registration database. Make sure the criteria are set to Username=Username and Password=Password. This DRW will also set the UserID cookie if there is a value in the database that matches the username and password.