Category: >> PHP Code >> Export mySQL results to CSV Bookmark and Share

<< lastnext >>

Snippet Name: Export mySQL results to CSV

Description: This script will export the results of a mySQL query to a Comma Separated Value (CSV ) format. Very handy for importing and exporting data.

Also see:
» Get Query String with Javascript
» UPDATE: Update based on a query
» Display stock quotes from a CSV fi...
» A minus B query
» Extract Search Query from Referer
» Export table to Excel or MS Word f...
» Export table to pipe delimited file
» Update and Subtract single query
» CaSe sEnsiTvE query

Comment: (none)

Author: CoderZone
Language: PHP
Highlight Mode: PHP
Last Modified: March 16th, 2009

// Export to CSV
if($_GET['action'] == 'export') {
$rsSearchResults = mysql_query($sql, $db) or die(mysql_error());
$out = '';
$fields = mysql_list_fields('database','table',$db);
$columns = mysql_num_fields($fields);
// Put the name of all fields
for ($i = 0; $i < $columns; $i++) {
$l=mysql_field_name($fields, $i);
$out .= '"'.$l.'",';
$out .="\n";
// Add all values in the table
while ($l = mysql_fetch_array($rsSearchResults)) {
for ($i = 0; $i < $columns; $i++) {
$out .='"'.$l["$i"].'",';
$out .="\n";
// Output to browser with appropriate mime type, you choose ;)
header("Content-type: text/x-csv");
//header("Content-type: text/csv");
//header("Content-type: application/csv");
header("Content-Disposition: attachment; filename=search_results.csv");
echo $out;
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 11