CoderZone.org

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
» EXPORT
» 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;
 
exit;
 
}
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7