About Joshua Lande's Picture Web page

This web page holds and displays my photos.

All images are stored in a SQL database. The database is initialized here
Here is an ERD for the database:

---  +----------+
---  | Album    |
---  +----------+
---  | id       |
---  | name     |
---  +----------+
---      |    
---      |    
---     /|\      
---  +-------------+         
---  | Picture     |
---  +-------------+
---  | id          |
---  | album       |
---  | location    |
---  | title       |
---  | description |
---  +-------------+

The database is maintained and modified through the picture_database class. It is stored here

Tests are run on the database at test.pl

The autohandler is here

The main page is drawn at index.html

The main page consists of 3 tables, drawn with the mason components display_links and display_middle

The list of albums (seen on this web page too) is drawn with the mason component display_albums

The CSS style sheet is here

Sadly, I could not get file upload to work, and thus you cannot add pictures to the database. That sucks :/ But I couldn't get the technicalities of it to work. Here is where i tried to get it to work. I know that it dosn't compile now, but it did and I couldn't get it to work regardless of what i tried. I wanted to use the HTTP::File perl module to get it to work. The CPAN description of it is here. But none of the recepies worked. Sorry.

That's about it. I hope you enjoy!