IT 202 - Web and Multimedia Technology

Lab 13 - Fall 2007

For this lab assignment, you will use the MySQL database to store data that enter on one web page and retreive from another web page.

Refer to the pages at The W3Schools PHP MySQL Introduction for examples on how this is done. The lab assignment will nearly mirror what is being done on those pages.

1. Create a table in a MySQL Database that has will store information about a music or book collection. Your database is to store at least the following information (you are welcome to store more information):
   • The Name of the Author/Artist
   • The Title of the Book/Song
   • The Year the Book/Song was published/released
   Optional additional information for a book might include the Series Name if the book is part of a series of books, or the name of the publisher. Optional additional information for music might include the Album Name or the name of the record company.

2. Create a web page that allows the user to enter in data to be stored in the database. When a submit button is clicked, the data on the page is to be stored the database.

3. Create a web page that will retrieve the database and display the data in an HTML Table in (another?) web page.

4. Create a web page that will allow the user the select a subset of the data in the database and display the data in an HTML Table in (another?) web page. The user should be able to enter a value that will be used with the MySQL WHERE statement. Examples of this could be to show all of the books/song whose name begins with a whatever the user would have entered (check out the SYNTAX of the MySQL LIKE statement), or to show books/songs that were published/released in a certain year.

This lab assignment is to done in the lab in SEL 2264.