For my SQL class this semester we were asked to do a series of things that walked us through the creation of a great relational database. For my project our group decided on making a database for a fictional post-apocalyptic world where zombies are roaming the earth. Think watered down version of an application that could be used to keep track of the characters on popular television shows or movies. Another possible use for the design as discussed by my group is in making some sort of table top turn based game.
Wile the sole purpose of the project was just to create the database, not a front end, I decided to take things one step further for our deliverable for the end of the semester. I made it into a full LAMP stack website that demonstrated that the database and their queries can work with current web design standards.
Also this project allotted me a good excuse to learn a bit of PHP as I had minimal experience with it as a language prior to this experience. Ultimately while the code is clearly amateur it was a great way to learn a good variety of things such as but not limited to:
- Basic PHP formatting and syntax
- Using PHP to connect to a SQL database
- Using PHP to query and draw the output into HTML tables.
- POST and GET operations
- Full LAMP Stack design philosophy
Anyway here is a link to the project. I will probably keep it up indefinitely or until I decide I want to use that particular VPS for something different.