Just a quicky post, that I hope will save someone (or myself) some head-scratching later.
TLDR: Whenever you
fopen('php://temp', $mode) you get a new file.
I found this out when exporting some data from the DB to a spreadsheet/CSV. I was using
Symfony bundle around
phpoffice/phpspreadsheet) which had a handy method to save the file:
$writer = $this->spreadsheetFactory->createWriter($spreadsheet, '.csv'); $writer->save('php://temp');
From there I would read it back, and upload it to a cloudfiles storage account using FlySystem:
$tempFp = fopen('php://temp', 'rb'); $wroteStreamOK = $this->securedFilesystem ->writeStream('/path/in/cloudfiles/filename-etc.xlsx', $tempFp);
An advantage of using ‘php://temp’ is that it’s usually stored in memory, unless it gets too large (over 2MB, usually), in which case it’s automatically saved to disk. Thats one less thing to worry about, right?
Another export-to-CSV was a bit simpler, and so it looped through the database records, and output them directly, using
fputcsv - and it worked great. When I didn’t realise was that that didn’t open
php://temp twice - it opened it directly, saved to it, rewound the file-pointer, and used that file-handle to upload.
$writer->save('php://temp'); it was being opened, and then re-opened
$tempFp = fopen('php://temp', 'rb') - so, I got a second, different temporary file - which was empty.
As usual the fix was actually pretty easy, when the underlying problem was recognised.
- Open the temp file ourselves, & let the spreadsheet bundle use it (
$writer->save()happily takes a file-handle/resource directly instead of the filename/path which it must open itself)
- Use the same file-handle for the upload (it even does a
// get the `resource`/file-handle for the temporary stream // we use to save the initial export. We need to be able to // use the identical resource-id to be able to save it later $tempFp = fopen('php://temp', 'rw+b'); $writer->save($tempFp); $filepath = sprintf('%s/product_exports_venue%d.%s.%s.csv', /* etc... */); // write the CSV lines to the final file (local directory or the cloud, via Flysystem) $wroteStreamOK = $this->securedFilesystem->writeStream($filepath, $tempFp);
- Stackoverflow: Having problems reading/writing the php://temp stream
- PHP.net: php://memory and php://temp