Handling a BLOB (zip file) called from MySQL
| From: | SpyProductions Support Team | Date: | Fri, 31 Oct 2003 13:45:24 +0000 |
| Subject: | Handling a BLOB (zip file) called from MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-168223@lists.php.net to get a copy of this message | ||
I am trying to figure out how to best handle a record that contains a zip
file (BLOB) in MySQL.
When I call it out from the table, is the best way to handle the file by
writing it to a temporary directory?
The BLOB represents a '.zip' file, so should I be using: zip_open /zip_read
/ zip_close when loading and retrieving the file to/from the data table? Or
would fopen and such in binary mode be sufficient?
I don't need to open the zip file and see what is inside per se - just want
to store into the data table and pull it out as a file that can be
downloaded.
:)
Thanks!
-Mike