Posted By

FatFolderDesigner on 09/03/11

Tagged

mysql
php
simple
csv

Versions (?)

Last Edited at 09/03/11 11:34am

Statistics

Viewed 907 times

Favorited by 0 user(s)

Related snippets

Simple MySQL to CSV

/ Published in: PHP

Just a short little script that takes a mysql query and turns it into a csv file that downloads automatically. If your interested in the details you can hit up the link.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

require '../includes/init.php'; // This connects to the database
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=client_export.csv");
header("Pragma: no-cache");
header("Expires: 0");
$q=mysql_query('select * from users');
while($r=mysql_fetch_array($q)){
	foreach($r as $k => $v){
		if(is_numeric($k)){
			echo '"'.str_replace('"', '""', $v).'",';
		}
	}
	echo "\n";
}