The Picture Database

Your task is to make a database of pictures. Users can log in. Users who have the correct permissions can then add pictures to the database. They add pictures by telling the database the URL of the picture to be added. The database then goes and gets the picture, copying it into the database itself. After the picture is added, the user can modify the attributes of the picture. Here they can add keywords to describe the picture, and add authorship information.

This database has a search feature. A user can search the database and find all pictures of a given size matching given keywords.

This database has delete screen, where users who have logged in with the appropriate permissions can delete pictures from the database.

Other things that get one points:

Uses at least 100 lines of Perl and 100 lines of PHP (5 points).
Uses a PHP or Perl object (3 points).
Done before finals week starts (+20%)
Done After the Tuesday of finals week (-20%)
Done after the Friday of finals week (0 points total).

How to convert an image of one size to an image of another:

            if (its_a_JPG_file) {
                    $command = "djpeg < $file | pnmscale -ysize $HEIGHT | cjpeg > $thumbfile";
             }
             else {
                    $command = "giftopnm < $file | pnmscale -ysize $HEIGHT | cjpeg > $thumbfile";
             }
             #print "$command\n";
             system($command);

This project is out of 68 points. In real life, one can get up to 90 points.

This program counts for as much as TWO standard programs. This program is a BIG DEAL IN THE GRADE BOOK!

The Add-A-Picture Screen (12 points)

Asks for a URL of a picture to download.
Gets the picture. (10 point)
If successful, prints a success message and offers a link to the edit-the-picture screen. (1 point)
If unsuccessful, prints an error message and offers a link to try again. (1 point)

The Edit-A-Picture Screen (12 points)

Shows the existing keywords for the picture. (2 points)
Allows the user to change the keywords (2 points)
Prevents the user from adding the same keyword twice (3 points)
Prevents the user from adding a banned keyword (3 points)
Has a delete-the-picture button (2 points)

The Search-For-A-Picture Screen (10 or 20 points)

Asks for a set of keywords
Finds pictures that match the keywords (4 points)
Shows each picture (4 points) OR shows a thumbnail page of the pictures (14 points)
Clicking on the picture takes on to the edit-the-picture page (2 points)

The Login Screen (12 points)

Asks for the username and password
Verifies these against a database. (3 points)
Sets a cookie the allows access to the database. (3 points)
The other pages honor this cookie, and limit themselves accordingly (6 points)
Should the cookie be permenent?

The Add-A-User Page (3 points)

Allows one to add a user. (1 point)
Only the PictureMaster can do this (1 point)
Refuses to allow a duplicate user (1 point)

The Delete-A-User Page (3 points)

Allows one to delete a user (1 points)
Only the PictureMaster can do this (1 points)
Complains if you try to delete a non-existant user (1 points)

The Random-Picture Page (6 points)

Pops up a random picture
Also tells the keywords for the picture.
Offers a link to the edit-the-picture page.
Offers a like to the next-random-picture page.