Right now the club's front page has a slideshow of club members doing club-y stuff.(link) The members of the club wish to be able to change the images in the slideshow from time to time. Right now the current system is for them to send me an image. I crop the image to the right resolution and send it server side using sftp. Then I have to modify the index.php file to include the new image + alt text. The final step is using RIT's web manager to push everything to the production server. This is all really basic and easy since I program. However in the future the club might not have a programmer available to do this.
My goal this weekend is to create a web interface for uploading and deleting images from the slide show. This should allow club admins to easily modify the front page of the website.
- Simple web interface to upload and delete images from the server
- RIT LDAP authentication using a database of admin user names
- Database storing image location on server + image information (photographer, alt text, etc)
- modified index.php with generic data structure filled with info from the database
I only have passing knowledge of both PHP and SQL so this whole project should be rather interesting. I don't think it's going to be incredibly hard. Most of the work should be researching how to do the things I want in PHP.
- RIT LDAP PHP http://bjcpgd.cias.rit.edu/wordpress/archives/6
- PHP uploading http://www.tizag.com/phpT/fileupload.php
- PHP Database http://www.devshed.com/c/a/PHP/Website-Database-Basics-With-PHP-and-MySQL/