hi, this pear package is working beautifully, but so far i've only managed to generate .xls docs. are there any formatting commands that would allow me to generate just a tab delimited text file? thanks redmond [Fri, Feb 11, 2005 at 12:41:42AM +0100] This one time, at band camp, Mirco Blitz said: > 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@xxxxxxxxxxxxxxxx] > Gesendet: Freitag, 11. Februar 2005 00:02 > An: php-general@xxxxxxxxxxxxx > Betreff: 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- Redmond Militante Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p10 #0: Wed Sep 29 17:17:49 CDT 2004 i386 1:00PM up 1 day, 16 mins, 2 users, load averages: 0.06, 0.06, 0.02
Attachment:
pgpg1MFAXjD29.pgp
Description: PGP signature
