mysql to CSV (Excel)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
myharshdesigner
Forum Commoner
Posts: 43
Joined: Sat Apr 21, 2007 8:23 pm

mysql to CSV (Excel)

Post by myharshdesigner »

how to get data from mysql to CSV (Excel) ?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

Take a look at the "SELECT * INTO OUTFILE 'file_name' export_options FROM" syntax.

file:///c:/docs/mysql/manual_SQL_Syntax.html#SELECT
(#10850)
myharshdesigner
Forum Commoner
Posts: 43
Joined: Sat Apr 21, 2007 8:23 pm

Post by myharshdesigner »

arborint wrote:Take a look at the "SELECT * INTO OUTFILE 'file_name' export_options FROM" syntax.

file:///c:/docs/mysql/manual_SQL_Syntax.html#SELECT

i just need to do it in PHP

so i need a simple php script .

how to import data into excel data
User avatar
superdezign
DevNet Master
Posts: 4135
Joined: Sat Jan 20, 2007 11:06 pm

Post by superdezign »

myharshdesigner wrote:i just need to do it in PHP

so i need a simple php script .

how to import data into excel data
Beggars can't be choosers. :P

What have you tried to this extent? It sounds like the smartest method to get data from MySQL to CSV is to cut out the middleman.
Post Reply