First, you guys are awesome!! As a total newbie, I have read this forum/tutorials extensively. Many writers have asked similar questions, but not quite in the detail I need as a newbie.
Desired tools:
PHP4, MySQL, Apache, Windows 98 (for development), Linux (on hosting company server)
What I want to do:
Allow authors to upload articles of varying length in .doc, .rtf and .ppt formats using a HTML form.
Automatically create a reference number in MySQL for each document to go along with the other data submitted via the form (e.g. title, abstract, date, etc.)
Rename/Copy each document to a specified directory on my hosting company's server using the reference number generated in step 2 so that the resulting files are "00001.doc", "00002.doc" etc.
This is what I want PHP/MySQL to do. Any help you can provide on the next steps will just be an unexpected bonus.
Download the new ".doc" and ".ppt" files and the MySQL table with the associated document information.
Somehow create a macro or use another program to format the documents including inserting fields into headers, etc. and using the MySQL table data (possibly converted into Access) to modify the document personalize each document by each record in the table.
Convert documents to .pdf in batch process. (I have software for this)
Extract document statistics (from document properties) and place in MySQL to present to end users. (e.g. extract number of pages, so users know how many pages the .pdf document is when presented for download).
This is a big request and I am focused on number 3 for this forum.
Thanks in advance for your responses. I hope this helps many and not just me.