On 9 November 2011 23:52, Matijn Woudt wrote:
> On Thu, Nov 10, 2011 at 12:32 AM, Ron Piggott
> wrote:
>>
>> I am wondering how phpmyadmin makes Excel files "on the fly" --- Is it a
>> class?
>>
>
> They used PHPExcel in the past, but they had to remove because of
> license issues. Don't know wha
On Thu, Nov 10, 2011 at 12:32 AM, Ron Piggott
wrote:
>
> I am wondering how phpmyadmin makes Excel files "on the fly" --- Is it a
> class?
>
They used PHPExcel in the past, but they had to remove because of
license issues. Don't know what they're currently using, but if you
can live with LGPL, PH
The problem you are describing is where the fields are not enclosed in
quotes. Are you specifying to enclose alpha type fields in quotes, and
leaving number-only fields without?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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") ) ) )
On 8 November 2011 18:31, 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
If the mysql server is set to allow remote access, then you could use
ODBC and