PHP Upload, Excel Updating
I made this site because I found that there were not enough examples of what I was working on with
php when I needed it. It was my first coop and my first time with php and excel, and I had a list of functions
from php.net but no basis on where to start. Most of what I needed
was working with excel, but there is no documentation for that for the most part. Hopefully this will help
someone out there. A fair warning though. Sometimes Excel will leave a zombie process out there. The Release
function of php should fix this, however, in PHP 5 (currently), Release will bomb out.
- PHP.ini - My php.ini file. Very important, although mine is farily basic. Uncomment lines where extension=something
to get additional features. I used the graphing ones for some of mine.
- httpd.conf - My httpd.conf file for apache. Need to customize to point to your php directory, otherwise, it should work.
- project page - The main page. One that I was happy to get working because it was working with excel finally.
- add page - Page to add a new project to the site.
- upload - called by add, the only thing that the user sees is it redirect to the main project page. However, the fun stuff
is in here. It uploads files, changes names of files, and edits the EXCEL file all in this page. Took me a little while to learn how to do, so I was
pretty happy when I finally got it to do everything. Move_uploaded_files is the key to the file upload. Check it out, it has way more versatility
than anything else I have found for uploading, especially vbscript.