PHPZAG.COM

php – convert mysql data to csv files

May 13th, 2012 by laeeq | 2 comments

During development sometimes we required php function to convert mysql data to csv files.
Below is the PHP example that takes a mysql query and turns it into a csv file that download file automatically.

Example Code:

view plain copy to clipboard print ?

<?php
header(“Content-type: text/csv”);
header(“Content-Disposition: attachment; filename=export.csv”);
header(“Pragma: no-cache”);
header(“Expires: 0″);
$mysqlquery=mysql_query(‘select * from employee’);
while($data_array=mysql_fetch_array($mysqlquery)){
foreach($data_array as $key => $val){
if(is_numeric($key)){
echo ‘”‘.str_replace(‘”‘, ‘”"‘, $val).‘”,’;
}
}
echo “\n”;
}
?>

<?php header(“Content-type: text/csv”); header(“Content-Disposition: attachment; filename=export.csv”); header(“Pragma: no-cache”); header(“Expires: 0″); $mysqlquery=mysql_query(‘select * from employee’); while($data_array=mysql_fetch_array($mysqlquery)){ foreach($data_array as $key => $val){ if(is_numeric($key)){ echo ‘”‘.str_replace(‘”‘, ‘”"‘, $val).’”,’; } } echo “\n”; } ?>

Hope it will work for you!

Follow @phpzag

You can subscribe to PHPZAG.COM posts by Email

php – convert mysql data to csv files

Example Code:

Web Development Topic