PHP Create Multiple CSV Files in Memory then Compress

Question

I have a requirement to create 3 CSV files (in memory) during a single HTTP request, ZIP the files into a single compressed file and return the compressed file as a HTTP response.

I have the following code to create the zip file...

$files = array($file1, $file2);
$zipname = 'file.zip';
$zip = new ZipArchive;
$zip->open($zipname, ZipArchive::CREATE);
foreach ($files as $file) {
    $zip->addFile($file);
}
$zip->close();

header('Content-Type: application/zip');
header('Content-disposition: attachment; filename='.$zipname);
header('Content-Length: ' . filesize($zipname));
readfile($zipname);

However, I don't know how to create the CSV files in memory.

How can I achieve this?

Ha! We're working on exactly the same project. … Fred?

Parapluie
– Parapluie

2022-12-20 18:46:16 +00:00
Commented Dec 20, 2022 at 18:46 — Parapluie
– Parapluie, Commented Dec 20, 2022 at 18:46

Community · Accepted Answer · 2020-06-20 09:12:55Z

Try this...

// some data to be used in the csv files
$headers = array('id', 'name', 'age', 'species');
$records = array(
    array('1', 'gise', '4', 'cat'),
    array('2', 'hek2mgl', '36', 'human')
);

// create your zip file
$zipname = 'file.zip';
$zip = new ZipArchive;
$zip->open($zipname, ZipArchive::CREATE);

// loop to create 3 csv files
for ($i = 0; $i < 3; $i++) {

    // create a temporary file
    $fd = fopen('php://temp/maxmemory:1048576', 'w');
    if (false === $fd) {
        die('Failed to create temporary file');
    }
    
    // write the data to csv
    fputcsv($fd, $headers);
    foreach($records as $record) {
        fputcsv($fd, $record);
    }

    // return to the start of the stream
    rewind($fd);
     
    // add the in-memory file to the archive, giving a name
    $zip->addFromString('file-'.$i.'.csv', stream_get_contents($fd) );
    //close the file
    fclose($fd);
}
// close the archive
$zip->close();


header('Content-Type: application/zip');
header('Content-disposition: attachment; filename='.$zipname);
header('Content-Length: ' . filesize($zipname));
readfile($zipname);

// remove the zip archive
// you could also use the temp file method above for this.
unlink($zipname);

I've just tested this on my machine and it works fine.

I used this link as a reference, It may be useful.

MetaShock Reference

Marek · Accepted Answer · 2014-12-30 15:50:27Z

0

You can use php's memory wrapper:

$zipname = 'php://memory';

On systems having /dev/shm filesystem you can create files there, they will be kept only in memory and only accessible to current process. Don't forget to remove them after sending, web server process will keep running.

edited Dec 30, 2014 at 15:50

answered Dec 30, 2014 at 15:28

Marek

7,4431 gold badge24 silver badges34 bronze badges

2 Comments

fml Over a year ago

Will this support multiple files? For instance...$zipname1 = 'php://memory';$zipname2 = 'php://memory'; $zipname3 = 'php://memory';

Marek Over a year ago

Each fopen('php://memory', $mode) will open separate in moemory file. The problem is they are not named, closing the file pointer will loose what was written. I don't know ZipArchive library to know if this is a problem, likely you should not call $zip->close() but something else to get the stream. There's yet another solution, I'll update my answer.

Collectives™ on Stack Overflow

PHP Create Multiple CSV Files in Memory then Compress

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related