I need to export MYSQL data to an excel or csv file

jomama

This is probably a toughie but I know it is possible. I am trying to generate an excel or csv file with data populated from a query with varying criteria.

Basic process from User's side:
Select criteria => Click "generate CSV" => Screen pops-up prompting user to select a location to store generated file => User clicks "save"

Does anybody know how to do this?

Any help would be appreciated.

Thanks,
Josu

Sxooter

If you just want raw data with no formulas etc... just toss a content header and tab seperated data and excel will eat it up.

header ("content-type: application/excel"); # <- I'm pretty sure this is the wrong header, just check the mime types on your system for excel.

Then just output the data seperated by tabs (\t).

BeastRider

Do you have access to myPHPAdmin? It does a nice job of exporting in several different formats, including CVS and CVS for Excel.

jomama

I tried to find myPHPAdmin and could only find dead pages where the application was once available. Any suggestions on finding a stable copy?

As for the suggestion to :
header ("content-type: application/excel");
then output the data seperated by tabs:

I am confused how that would work. How would you make the output data go to the exported data. Do you implode all the data to a variable then put the header code? I really can't fathom it so far but I am sure you're right. Please help me see what you mean. Please explain the general flow at least if you could.

Thanks in advance.
Josu

BeastRider

Is your MySql database located on a remote server (that is a web hosting service) or are you running this database locally on your own machine or LAN?

jomama

The mySQL db has its own domain. It is all developed locally and tested remotely.

Thanks

BeastRider

Then if you wish to use MyphpAdmin remotely, the folks running your MySql domain must set it up, unless you have access to their services with a remote server connection.

It strikes me that the best place for these questions would be with the folks that are running your db... they are the only ones that can allow you in with anything.

PS: What is developed locally? The php code? How do you upload a database to the other domain right now? Can you download the database you want to export. If so, you can use ODBC and bring the MySql tables into an Access DB as linked tables. Then you can export them however you want.