Re: AW: [PHP] export mysql to csv prob

If your mysql server has access (or can have access) to the directory where you want to dump the file, you can just use the "SELECT.... INTO OUTFILE FIELDS TERMINATED BY ','..." syntax as your query, which is very fast. Mirco Blitz wrote:

Hi, Probably the Pear Excel_Syltesheet_Writer works for you. http://pear.php.net/package/Spreadsheet_Excel_Writer I found out that it is faster with huge data sets on my system. Greetings Mirco -----Ursprüngliche Nachricht----- Von: Redmond Militante [mailto:r-militante@northwestern.edu] Gesendet: Freitag, 11. Februar 2005 00:02 An: php-general@lists.php.net Betreff: [PHP] export mysql to csv prob hi i have a script that exports the result of a mysql query to a csv file suitable for downloading the code looks like $result = mysql_query("select * from user,mjp1,mjp2,mjp3,mjp4");

while($row = mysql_fetch_array($result)) {     $csv_output .= "$row[userid] $row[firstname] $row[lastname]\n" }

header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".xls"); print $csv_output; this works fine, except that when i expand the line $csv_output .="$row[userid] $row[firstname] $row[lastname] $row[anotherfield] $row[anotherfield] ...\n"} -to include an increasing number of fields, it tends to bog down the speed at which the $csv_output file can be printed. when i have this line output 30+ fields for each row, wait time for output file generation is almost 4-5 minutes. is this the most efficient way to do this? i'd like to be able to generate the file as quickly as possible. thanks redmond -- Redmond Militante Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p10 #0: Wed Sep 29 17:17:49 CDT 2004 i386 4:45PM up 4:01, 3 users, load averages: 0.00, 0.00, 0.00