Feb 032007
 

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
 Posted by at 02:22

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)