Band Event Listing Backend
I am looking for someone to design a PHP script to output information from a MySQL 4.0 or 5.0 database that will be included in a webpage for a band.
Here are the desired features:
Gig Guide
– Output standards compliant HTML which I will format using CSS and style to fit a page’s look and feel.
– A table containing the names, addresses, emails etc for venues that the band plays in regularly.
– A table of gigs that the band will play. Fields here will have Date, time, cost, VENUE (linked to the table of venues) and some copy to be displayed with the text.
– An admin section which will require a username and password to gain access, and will allow the admin user to add, remove and edit gigs/events and venues as well as to control the date range of the output of the script.
The final output of this script will display all the gigs within a selectable (from the admin section) time frame, both past and future gigs will need to be displayed. This script’s output will be included in another php page.
Music Download
– Output standards compliant HTML which I will format using CSS and style to fit the page’s look and feel.
– Basically a list of files that can be downloaded.
– An admin page accessible via username and password (preferable that the credentials for this page are the same as the gig guide page) that will allow you to add/edit and delete the files displayed, as well as to hide and show particular files and sort the files.
Please note that no database currently exists, so your script will need to be able to set up its own tables and populate them with data from user entry.