I decided to do this project as a way to keep track of what bottles of craft beer I had in my beer fridge. At the time I was just finishing a Web Design class using PHP and SQL databases, I choose to use what I had leaned for this project.

I chose to have three main tables in my database: Breweries, Beers, and Styles. The Breweries table contains a list of brewery names, and brewery IDs. The Beers table contains the beer name, Alcohol By Volume (ABV), a description, Quantity, style ID, Brewery ID and filename for the display image. Finally, the Style table contains a style ID, style name, and a description of the style.

At this point, I set up a simple web interface that would allow me to add/delete breweries, styles, and beers in the database. The main page of this is shown below.

Next, I created the list of beers. This displays all beers in the database with a quantity of at least one. As shown in the image below, it displays the beer's information along with an image of the label and a button to 'take one'. This button will automatically subtract one from the quantity and refresh the page.

As shown in the image above, if the description is too long it is cut off with the words '...(see more)'. Hovering the mouse over the text will bring up a box with the full description, as shown below.