I need a photo album written in PHP and mySQL.
Features:
Admin Area: (requires logon)
1) Create, Edit and Delete Categories
2) Create, Edit and Delete Photos
2) Ability to set maximum file size for pictures.
3) Approve photo submisions amde in the user area.
User area:
1) Main page lists categories and below that shows the most recently added photos.
2) Category name is also the <title> of the page
2) Auto thumbnail pictures and display them in categories. If possible, it would be nice to have the ability to set the number of rows and columns per page.
3) Ability to submit picture, title and description. Title of picture is also the <title> of the page.
Notes:
1) Store the pictures in a file on the server, not mysql.
2) Please provide .sql file to set up the tables initially.
3) I would like all pages to reference './includes/[login to view URL]' and './includes/[login to view URL]'. I'll provide the cotent of those files myself.
4) It would be helpful if the code is written in such a way where it's easy to add new fields to the pictures table and add them to the output.
5) Please code to prevent sql injection attacks on user submission form.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
I'm running apache on linux.