How to Write a CSV Directly to PHP://Output I/O Buffer With fputcsv()

Came across this gem half-way down the function page for fputcsv() on php.net

// Send headers for file header( 'Content-Type: text/csv' ); header( 'Content-Disposition: attachment;filename='.$filename); // open buffer to write file to browser $fp = fopen('php://output', 'w');

// Table Headings row fputcsv($fp, array_keys($row));

// Write rows to buffer while($row = mysql_fetch_assoc($result)) { fputcsv($fp, $row); }

Use an associative array for this so your keys will be the csv headers.

Enjoy!

Tags: CSV, PHP