DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Export Mysql Results To CSV

10.15.2009
| 4331 views |
  • submit to reddit
        
// 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;

}