FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Send .csv file to browser
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Send .csv file to browser [message #170003] Tue, 05 October 2010 14:19 Go to previous message
Derek Turner is currently offline  Derek Turner
Messages: 48
Registered: October 2010
Karma:
Member
I want to use MySQL to get a list of email addresses and names and then
output a .csv file to the browser so that it can be saved and then
imported into Thunderbird etc.

Having googled around I think the solution will be:

1. Create and open a local file for writing

2. Write the data to the local file and close it

3. Use appropriate header files and then readfile()

4. Delete the local file

Questions:

1. Is this a reasonable approach? Or should I be outputting to the
browser on the fly? Or using PEAR or something like that?

2. Can the headers appear appear anywhere in the script or must they be
be the first lines?

Other questions depend on your answers to those two, so I'll keep them to
myself for the moment.

<off topic>

I've exported from TB to see what its .csv output file looks like.

1. Do I really need to include all those fields?

2. Will, for example, OE import them properly?

</OT>

tia

Derek
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: file access permission?
Next Topic: Process queue without cron jobs
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 08:11:12 GMT 2024

Total time taken to generate the page: 0.04224 seconds