PHP: SUCCESS!

I've got an upload form working on the Rock Climbing Club staging server. As soon as I get the time I'll create and populate a database on the production server and push this live! Now officers will be able to upload photos with the click of a button. Next I want to look at possibly moving to a Flickr API or, if that fails, write a graphical interface with delete functionality. If you haven't yet, check out the club's website! http://www.rit.edu/rocks/ Now with 100% faster picture uploads!

PHP mini-project Update

I hit a small roadblock this weekend trying to get file uploading to work. That plus my AI homework really slowed down the project. I'm still banging away at it. Today I managed to get uploads to the web server. Next steps: Get the uploads to the right place. Password protect it! (O_O) Then I'm going to get the app pushing information to a database. From there I'll get the front page of the website reading information from that database.

PHP: Photo Hero Project

So I'm the webmaster of the RIT Rock Climbing Club. What this basically means as far as the club is concerned is that I'm the only one that knows what a terminal window is. I figure since I know a thing or two more than that I should write some code to help future members of the club. So here's my idea:

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.

Goals:

• 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.

Useful links:

• 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/