User:KingOfZeal/Projects/Shop Database

= The Shop Database =

The Premise
The Shop Database was originally made for the flag I am in, Caper's Capers, as a way to keep track of where our shops were in the flag, without having to keep a spreadsheet updated.

Basic Information
The Shop Database is written in PHP, with a mySQL database backend. As of right now, the database only accommodates the flag it was written for. However, depending on feedback from other people, I may integrate a multi-flag function into it.

Without a doubt, of the scripts I have written to date, this is my favorite, both in layout and in features. While the backbone of the script was based off the Ship database, many features were dropped, such as the admin function. However, in writing this, I did manage to learn many new things about PHP/mySQL, and this was also the first script I wrote entirely using a developers server on my computer: Instead of uploading a revised file every time one little error is made, I instead host a local server on my computer, with PHP and a copy of the mySQL database I use, so it's easier to fix mistakes, and ensures the final (published) script is working perfectly. This also allows me to use test data in the database, that won't exist in the final database.

Screenshots
All images are external links.

Image 1 Image 2 Image 3 Image 4 Image 5 Image 6 Image 7