PHP export to CSV

Here's a short PHP script to export data to a CSV file.

I'll start with a PHP array. You can extend this to query a database or something similar.


//the stuff we want to export
$arr = array();
$arr[] = array('Banana', 'Yellow');
$arr[] = array('Apple', 'Red');
$arr[] = array('Apple', 'Green');
$arr[] = array('Orange', 'Orange');
$arr[] = array('Grape', 'Green');
$arr[] = array('Mandarin', 'Orange');
$arr[] = array('Kiwifruit', 'Green');


Now we build our CSV output as we loop through the array with the foreach construct.


$csv = "Fruit,Colour\n";
foreach($arr as $row){
$csv .= "{$row[0]},{$row[1]}\n";
}


Then we output the file to the web browser with the headers set to our content type.


header ( "Content-Type: application/force-download" );
header ( "Content-Type: application/octet-stream" );
header ( "Content-Type: application/download" );
header ( "Content-Type: text/csv" );
header ( "Content-Disposition: attachment; filename=fruit.csv");


• Slashdot it!
• Digg it:
  
• Del.icio.us