online zip modifier

How can I transfer the contents of a blob-field from a mySQL-db (assumed this contains a zip-archive) in a ZIP-object without having to save it first in the file system of the server?
Kind regards and many thanks for your work

Hi,
Thanks for your question. It is not so hard. retrieve the data from the db in a variable say $b_data and then use the following line to put that on zip.

$zipfile1->create_file($b_data, "usetest/usecode.php"); // Add a file into zip the loaded zip

Hope it will help u

Regards
Hasan

I think, this is probably a misunderstanding. My question might have been ambiguous - because of my poor English.
The process is as follows: I bundle a varying number of small files in a zip-file that is stored in a BLOB-field. In reverse direction the files in the Zip archive are to be delivered. In order to do that the Blob-Field is read out and a ZIP file is created in the filesystem of the server. Finally this is read from the hard disk and opened to extract and deliver the containing entries.
My hope is to avoid the writing to the filesystem. Instead I would like to read the character string (I receive from the BLOB-field) directly into a ZIP object.
I think your class could be a solution for this task. However, up to now I was not able to figure out how. Can You help me?

Hi,
I think your solution is in my last post. Well let me make it more clear. So far i understand you want to add some file into a zip archive but the file data will come from a blob field. If yes then first retrieve the data from the blob field and keep it on some variable (i used the variable $b_data at my prev post for this). Then suppose the name of the file in the zip archive is usecode.php and it will be under the folder (in the zip archive) usetest. So to add the file into zip archive u need to use this following line.

$zipfile1->create_file($b_data, "usetest/usecode.php");

here $zipfile1 is the instance of the zipfile class

Hope now it is cleared to you.

Regards

Hi, many thanks for your response.

> So far i understand you want to add some file into a zip archive but the
> file data will come from a blob field

I am sorry, but this is not the problem. The zip file comes from the db and the data contained in the zip-file has to be unpacked and be handed on.
At the moment the ZIP file is written to the filesystem and then is loaded anew:

(1) $result = file_put_contents('newzipfile.zip', $datafromdb, LOCK_EX);
(2) $myZip = new ZipArchive;
(3) $myZip->open('newzipfile.zip');

I would like to avoid steps (2) and (3).

Yours sincerely