PHP: Export Query Results to a CSV File

gistfile1.aw

<?php
// (c) 2007 Lukasz Grzegorz Maciak
// Code Snippet ID: 5e8cf864-db67-4a30-9857-2ce8f3fcb1d5
 
// takes a database resource returned by a query
function csv_from_mysql_resource($resource)
{
	$output = "";
	$headers_printed = false;
 
	while($row = mysql_fetch_array($resource, MYSQL_ASSOC))
	{
		// print out column names as the first row
		if(!$headers_printed)
		{
			$output .= join(',', array_keys($row)) ."\n";
			$headers_printed = true;
		}
 
		// remove newlines from all the fields and
		// surround them with quote marks
		foreach ($row as &$value)
		{
			$value = str_replace("\r\n", "", $value);
			$value = "\"" . $value . "\"";
		}
 
		$output .= join(',', $row)."\n";
 
	}
 
	// set the headers
	$size_in_bytes = strlen($output);
	header("Content-type: application/vnd.ms-excel");
	header("Content-disposition:  attachment; filename=export_data.csv; size=$size_in_bytes");
 
	// send output
	print $output;
	exit;
}
 
?>