BLOB, SQL, and FTP
Posted: Sun Apr 09, 2006 2:05 pm
Hello,
I am new here and this may be an easy question... not sure. I did search but didn't find anything on this. Basically here is the situation:
We are currently working on a program in mainly PHP and MySQL. We currently have a working section of the program that allows for Uploading of .jpg, .eps, and .swf files into BLOB storage in a MySQL database. We also have working preview pages of these files.
The problem lies in this:
We have a need to be able to pull multiple files directly from the BLOB status and FTP them to another site for conventional storage (I.E. in folders on that site). This will all be done with no updating or previewing of the data, just sending (up to 100 files at a time potentially).
Has anyone out there ever tried this, and if so, could you please point me in the right direction?
Any knowledge or help is greatly appreciated.
Thank you!
I am new here and this may be an easy question... not sure. I did search but didn't find anything on this. Basically here is the situation:
We are currently working on a program in mainly PHP and MySQL. We currently have a working section of the program that allows for Uploading of .jpg, .eps, and .swf files into BLOB storage in a MySQL database. We also have working preview pages of these files.
The problem lies in this:
We have a need to be able to pull multiple files directly from the BLOB status and FTP them to another site for conventional storage (I.E. in folders on that site). This will all be done with no updating or previewing of the data, just sending (up to 100 files at a time potentially).
Has anyone out there ever tried this, and if so, could you please point me in the right direction?
Any knowledge or help is greatly appreciated.
Thank you!