MySQL to CSV Export Example (mysql data export)
For a long time now I’ve been looking for a simple to use MySQL to CSV Export script. Every single MySQL data export example I found never quite worked properly or it never added the headings to the CSV file which was extremly annoying.
With a little help from this outstanding script (Parse to CSV PHP) I was able to build one that works extremly well on any MySQL database query. (Which is great if you just want to export a small database segment, most CSV export programs just grab the whole database table).
Basically it creates a 2D array of all the data that is pulled from your query so the Parse to CSV class can then output it to a CSV file.
Good luck, I hope this saves you some time.
Code Example Below:
<?php //Visit http://code.google.com/p/parsecsv-for-php/ for more info. //Connect to Database and perform your select $sql="SELECT * FROM `yourtable`"; $result=mysql_query($sql);
//Get the column names to add to the head of the CSV file $csvHeader = array(); $columns = mysql_num_fields($result); for($i = 0; $i < $columns; $i++) { $i; $csvHeader[] = mysql_field_name($result,$i); }
# include parseCSV class. require_once('parsecsv.lib.php');
# create new parseCSV object. $csv = new parseCSV();
//Turn the SQL results into a 2D array $DataArray = array(); while($row = mysql_fetch_assoc($result)) { $DataArray[] = $row; }
//$csvHeader = array('Car name', 'color'); $csv->output (true, 'data.csv', $DataArray, $csvHeader);
?>