header('Content-type: application\/csv');\nheader('Content-Disposition: attachment; filename=myCSV.csv');\nheader(\"Content-Transfer-Encoding: UTF-8\");<\/code><\/pre>\n\n\n\nSetting the header is importance when downloading files automatically. In the first line of code, the content-type <\/strong>option is that HTTP header telling the browser that the MIME type of the content is application\/csv. <\/p>\n\n\n\nOther particularly important option is in the second line of code, the filename <\/strong>option. This is where we want to name the file that will be generated and downloaded. <\/p>\n\n\n\n The other importance line of code is content transfer encoding<\/strong> ,this encoding method will transform binary email message data into the US-ASCII plain text format. <\/p>\n\n\n\nFor populating CSV, fopen() giving us access to PHP\u2019s output buffer. This line of code is that the file pointer connected to the output stream.<\/p>\n\n\n\n
$f = fopen('php:\/\/output', 'a'); <\/code><\/pre>\n\n\n\nWriting data to the Csv and we can define column headings like this:<\/p>\n\n\n\n
fputcsv($f, array('Column 1', 'Column 2', 'Column 3'));<\/code><\/pre>\n\n\n\nWe can fetch data and loop over the rows of data and output them. <\/p>\n\n\n\n
mysql_connect('localhost', 'username', 'password');\nmysql_select_db('database');\n$rows = mysql_query('SELECT field1,field2,field3 FROM table');\n\nwhile ($row = mysql_fetch_assoc($rows)) fputcsv($f, $row);<\/code><\/pre>\n\n\n\nBy Ami<\/p>\n
\n <\/g:plusone><\/div>\n
![\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"](\"\/\/b.hatena.ne.jp\/images\/entry-button\/button-only@2x.png\")
<\/a>