Last active
January 17, 2024 11:04
-
-
Save zuzuleinen/6db61b09465e9bc8a7ea to your computer and use it in GitHub Desktop.
CSV Response in Symfony controller action
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
use Symfony\Component\HttpFoundation\Response; | |
use Symfony\Bundle\FrameworkBundle\Controller\Controller; | |
class CsvController extends Controller | |
{ | |
/** | |
* Get a CSV file from an array | |
* | |
* @return \Symfony\Component\HttpFoundation\Response | |
*/ | |
public function csvAction() | |
{ | |
$list = array( | |
//these are the columns | |
array('Firstname', 'Lastname',), | |
//these are the rows | |
array('Andrei', 'Boar'), | |
array('John', 'Doe') | |
); | |
$fp = fopen('php://output', 'w'); | |
foreach ($list as $fields) { | |
fputcsv($fp, $fields); | |
} | |
$response = new Response(); | |
$response->headers->set('Content-Type', 'text/csv'); | |
//it's gonna output in a testing.csv file | |
$response->headers->set('Content-Disposition', 'attachment; filename="testing.csv"'); | |
return $response; | |
} | |
} |
Correct. But using php://temp
allow you to be smart, ie by using Symfony\Component\HttpFoundation\StreamedResponse
.
Agree
It's also worth to explain why one shouldn't write to php://output
in this case. That stream is the same one as the one used by echo
or print
statements. Obviously, you can also access it via ob_*
functions. The thing is - you've got no idea what's in it or who's going to write to it. I've had a case, where using it caused the Content-Type
of a response to randomly change between text/csv
and text/html
. In other words - weird things happened!
Switching to anything else, in my case to php://temp
(thanks Nyholm!), did the trick.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@Nyholm
But
stream_get_contents($fp)
has to load the file in memory anyway?