I have tried to implement a CSV solution.

Following a CSV header each field is displayed using this syntax: (Except the last doesn't end with a , but \r\n )


echo "\"" . trim( str_replace( '"' , '""' , stripslashes( mysql_result($listing_result , $i , "ministry_profiles.address_line_1") ) ) ) . "\" , ";

I have these 2 problems:

- Excel isn't providing a popup screen for me to specify the content of each field is contained within a pair of " and , is used to separate each field. - Additionally Excel is interpreting a comma as the start of a new field. This is problematic in fields where a comma legitimately exists in the middle of a field.

I am wondering how phpmyadmin makes Excel files "on the fly" --- Is it a class?

I am unsure how to proceed.


Ron Piggott



www.TheVerseOfTheDay.info

-----Original Message----- From: Jimi Thompson
Sent: Tuesday, November 08, 2011 4:59 PM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Exporting mySQL to Excel

The best option I've found is to write to a file that is then sent to
the browser for download.  Are there others?  Yes but that's the one
I've had the best experience with.  It seems to work reliably regardless
of browser or version of Office or any thing else.

HTH!

On Tue, 2011-11-08 at 13:31 -0500, Ron Piggott wrote:
What is the preferred method used to export mySQL to Excel within the context of PHP? I have looked on Google and found a wide variety of options. Ron

Ron Piggott



www.TheVerseOfTheDay.info


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to