Exploiting the Information World ITEC-2110 - Fall 2000 These exercises are part of your grade! For each exercise that you complete during class you must make record your results to show the TA (or show the TA your screen). If you don't have time to complete everything during class you must record your results and give them to the TA by the next class meeting.

EIW Exercises: CGI and Access Database

All you need to show us is step 3

1. Access Database

Create an Access Database with a table that holds user names and favorite colors (each record holds a user's name and favorite color). Create a few records in your database for testing.

Register your database with the ODBC manager (control panel).

2. Perl and Win32:ODBC

Write a perl program that prints out all the records in your database (using Win32::ODBC). This program doesn't need to be a CGI program, it's fine if it runs from the DOS command line.

3. CGI Program

Convert your Perl program into a CGI program that does the following:

• Gets a user name from a form field
• Looks up the user in the database.
• Sends back a document that has some text (I dont' care what) and the background color of the document matches the user's favorite color found in the database.

If the user does not exist in the database, you should send back and HTML document that states the the name is unknown. You don't need to support the creation of names,colors from a CGI program (you can enter all the records using Access)