Fall Semester 2007

We have:

• a data file with the initial users
• a script that creates the table, populates it with initial users
• running this script produces the following output (we will look at the database a bit later)

• a data file with the initial movies
• a script that creates the table, populates it with initial movies
• running this script produces the following output (again, we will look at the database a bit later)

• a data file with the initial ratings
• a script that creates the tables, populates them with initial ratings
• running this script produces the following output (and we can now take a look at the MySQL database)

• connecting to the database is through the mysql_client script we all have (here's mine)

• here's how my checking of the database and tables went

Having done this we can write:

• a CGI/Perl script that connects, extracts information from the database (program, source code)
• the same thing using PHP (program, source code)

What we need to do next:

• complete the design of the database
• write the SQL queries for extracting the information
• setup the screens, scripts and SQL for adding a user/movie to the database
• work out a collection of scripts that implements the user actions when reviewing a movie

The last part is like Chapter 13 in the text, which we should look over.