Build a query interface to a music database
Assignment for class #3

In this assignment you will create a forms-based interface to a music database stored in mySQL.

Note: It's best to implement this assignment incrementally. Get one piece working and then add a little more code -- it certainly helps with debugging.

1. Prepare your database: Use myPhpAdmin to create and populate a "song" database using the supplied script. (Hint: Go to the SQL tab and paste it in.)

2. Create a file named query.php in your web server's "root" directory (c:\wamp\www).

Create a form that accepts the following values as input: artist, title, and genre.

Include a "submit" button on your page.

The form should post to another file, results.php, which you will create in the next step.


3. Create a file named results.php. Print out the values posted to it.

Use the values in a query to the mySQL database.
(Here's an example on how to query a database. Best viewed in Firefox; in IE you'll have to "view source".)


4. Modify your "results" page to display the results in a table.

------

Here's an example of a web app that queries the "song" db.