Announcements

Here is the João's Fare Trade Coffee exercise sheet which we used a few weeks ago and will discuss again this week:
in-class-exercise-2.pdf.

October 26: A PHP example

Here is an example of 2 PHP files and one HTML file for providing a simple web interface to the menagerie database:
menagerie-web.zip. You will need to change the username and password to your own!
Also, you will need to set permissions, as explained in class (on Oct. 27).

The sheet we used for the in-class exercise is here.
The solutions to the exercise are here.

September 23: Another update to assignment 1

Assignment 1 was updated: question 11 was revised. The
updated assignment is here. Additionally,
table DIVEORDS was modified in the database, so queries for
question 12 would need to be changed. Students who have already answered
questions 11 and 12 can email their answers to the instructor and get credit
for their answers to the original questions. Everyone else should answer the
updated question, using the updated database.

September 17: Assignment 1 updated

Assignment 1 was updated: the database table "monkey" has a field called "name". The
updated assignment is here.