• Info
• Initial State
• View Source
• Run

Exercises

VS-B-7 User Records

VSP exercise to create user records

User record Example

The object of the exercise is to handle form data, and data held in a table. This is achieved with 4 separate stages. Each stage has a separate file.

1. Create a user table with a login name, password, real name and address. The login name is the primary key. This table can be made with a SQL file.
2. Write an application which gets data from a form and inserts it into a table.
3. Write a form to prompt for login details and pass to the query page.
4. Write a form for querying the table based on the login name. The login name in the query form will be a SQL LIKE string.

This example would be used in web sites that have some form of membership to gain access to information.