As a thingie to enhance my PHP knowledge (I can read it, but writing is something else) I’m creating my own photo-gallery application. I just started two days ago and can only work on it in my spare time, but I have the following in place now:
- PostgreSQL server installed; user, tablespace and database created
- Basic tables for users and their albums created
- Index page in PHP, basically displaying a login when you first access it, or the entries in the albums table when logged in
- Login page in PHP, checking the supplied username and password against the users-table in the database
- Logout page, destroying the session and return to the index-page like you first accessed it
To do:
- Store passwords as md5-hashes (or something) instead of plain-text
- Create an Items table (detail-records of albums table)
- Create an Item_types table (picture, movie, etc)
- Display pictures!
- Create a Tags table
- Create an Item_tags table (link between Items and Tags)
- Functionality (->page) to link tags to items (preferable AJAXified)
- Create tags-based search page