Inside Technique : Adding Site Registration
By Scott Isaacs

This is the first article in a new series demonstrating how to personalization and community features to your web-site. Each article will contain all the ASP scripts and SQL queries for a basic implementation. However, as with all database and transaction-based systems, you should do a careful review to meet an appropriate level of security, performance and error handling.

In writing the samples we are focusing on simplicity and clarity sometimes at the expense of robustness. To keep things straightforward, the user-interface used in all samples is very minimalistic. The web pages merely act as a demonstration on how to interface with the backend, rather than how to create a rich user experience.

In this article we are going to cover the first step and show you how to create a membership database. The membership directory supports the following features:

• Joining the Web-Site
• Logging in the Web-Site
• Changing Passwords
• Member List Administration

We organized this article into two parts. First we explain the backend database. The backend database includes the user table and all the stored procedures used to manipulate the data. Once finished, we explain the ASP scripts which interact with the backend database and produce the web-pages for the user.

First, we start with explaining the user table.

© 1997-2000 InsideDHTML.com, LLC. All rights reserved.