dumping data from database to flat file

[kaisar]

please help me
i need to create php script that will
dump data from database to flat file / csv. so user can download it using his / her browser.

thanks before ..

[ccgorman]

Create a php page of the format as follows:

function do_query($q,$s,$e) {
//connect to database
//run query ($q)
//fetch rows
//store results in variable with a
//seperator ($s) usually a tab and
//fields enclosed by ($e) usually a
//quote
//return result
}

header("Content-disposition: filename=$table.csv");
header("Content-type: application/octetstream");
header("Pragma: no-cache");
header("Expires: 0");

PRINT @do_query($query,"\t","\"");

That should do the trick

-David

[Anon]

kaisar
I never tried this in a php script but i've
ran it as a cron job.
select * from table into outfile "/path/to/download.txt" fields terminated by ",";
hope that helps

good day
gd