We need an admin control panel (back end) developed and a programmer who can work with a currently designed MySQL database.
The control panel will be built in PHP 5.0 or higher. The PHP cannot be built using any PHP frameworks. Just straight PHP is required and object oriented classes are acceptable.
Programmer must also be able to program to prevent SQL injections as well.
The admin control panel must be all done with HTML forms and a menu for the administrator to select for editing. The HTML forms must also be programmed for data validation in Javascript or PHP.
Control panel will have all of the following:
a. Category Manager
1. Add, Edit, and Delete Categories
2. Add a description for each category
3. Add an icon to display on the category button – The admin will be able to upload the icon from the control panel and that icon will be saved to a field in the categories table of the MySQL database.
b. Maintain companies
1. Add, Edit, and Delete Company
2. Maintain a title
3. Maintain a description
4. Edit Web Site
5. Upload one or more graphic or logo for each vendor.
6. Add contact information (address, city, state, zip, phone, fax, email)
The admin will also be able to attach companies to one or more existing categories. There will be a database table called categories_companies
One database field in the companies table will be called more_zipcodes and the admin must be able to add vendors to one or more zip code, separated by commas.
c. Maintain banner ads
1. Name a banner
2. Assign a hyperlink to the banner
3. Upload an ad graphic for each banner
4. Assign banners to one or more banner slots on the web site (there will be a database field in the banners table called “slots”. All slots will be separated by commas.
5. Specify the width and height of the banner
6. Assign hard-coded zip codes, separated by commas
7. Specify a start and end date for the banner.
8. Add banner ads to one or more categories
Maintain videos
1. Name a video
2. Embed a video from YouTube
3. Specify a start and end date for the banner.