|
|
Posted by Mirco Blitz on 02/11/05 01:41
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
Navigation:
[Reply to this message]
|