Export to CSV File

[leachus2002]

Hi,

 

I have a PHP web page that displays the results from an SQL query. I was wondering if there was anything out there that would allow my users to click a link and then export the results of that query to a CSV file?

 

Thanks

Matt

[micah1701]

sure, just format your output as a comma separated list and set your headers to output as a text file

<?php

header('Content-Type: text/plain');

// some stuff to get your object of sql $results

foreach($results as $row){
echo $row['column_1'].",".$row['column_2'].",".$row['column_3'].",."$row['etc']."\n";
}?>

[Psycho]

You don't want to "write" your own comma separated string. If there is any chance that the values would include commas or quote marks the output would not be valid.

 

Take a look at the function fputscsv(). And, if you don't want to create a physical file (which that function requires) then look at the first user submitted comment on that function in which the author provides a solution.