FUDforum: comp.lang.php » Send .csv file to browser

Home » Imported messages » comp.lang.php » Send .csv file to browser

Show: Today's Messages :: Polls :: Message Navigator

Re: Send .csv file to browser [message #170011 is a reply to message #170003]

Tue, 05 October 2010 15:25

Peter H. Coffin
Messages: 245
Registered: September 2010

Karma:

Senior Member

On 5 Oct 2010 14:19:04 GMT, Derek Turner wrote:
> 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

Too much work. It'll be easier and simpler to skip the local file part,
and just send the appropriate HTTP headers, then the file contents
directly.

> 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?

Just send it. This isn't some kind of file that you have to modify the
beginning of it in accordence with what you put into it later, so a
single pass straight out the chute is better.

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

Headers must be sent before you send *anything* else. Even that trailing
extra line ending in one of your inlcuded support files.

> 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?

Probably. CSV is a very positionally-oriented "protocol". If it's
looking for phone number in the 37th column, then it's going to load
what's in column 37 into a phone number. You can't generally mess around
with it. But what do you care how many fields you're sending. You're
writing a program to do it, so you have only to enter it once.

--
"Friendship is born at that moment when one person says to another,
'What! You too? I thought I was the only one!'"
--C.S. Lewis

Report message to a moderator

[Message index]

		Send .csv file to browser By: Derek Turner on Tue, 05 October 2010 14:19
		Re: Send .csv file to browser By: Derek Turner on Tue, 05 October 2010 14:20
		Re: Send .csv file to browser By: sheldonlg on Tue, 05 October 2010 14:55
		Re: Send .csv file to browser By: Derek Turner on Tue, 05 October 2010 15:06
		Re: Send .csv file to browser By: sheldonlg on Tue, 05 October 2010 15:11
		Re: Send .csv file to browser By: Peter H. Coffin on Wed, 06 October 2010 16:25
		Re: Send .csv file to browser By: Jerry Stuckle on Wed, 06 October 2010 16:28
		Re: Send .csv file to browser By: Peter H. Coffin on Thu, 07 October 2010 02:55
		Re: Send .csv file to browser By: Captain Paralytic on Tue, 05 October 2010 15:14
		Re: Send .csv file to browser By: sheldonlg on Tue, 05 October 2010 17:54
		Re: Send .csv file to browser By: Jerry Stuckle on Tue, 05 October 2010 16:05
		Re: Send .csv file to browser By: Derek Turner on Tue, 05 October 2010 16:52
		Re: Send .csv file to browser By: sheldonlg on Tue, 05 October 2010 18:06
		Re: Send .csv file to browser By: Adam Harvey on Wed, 06 October 2010 03:50
		Re: Send .csv file to browser By: Jerry Stuckle on Wed, 06 October 2010 11:19
		Re: Send .csv file to browser By: Adam Harvey on Thu, 07 October 2010 02:42
		Re: Send .csv file to browser By: Jerry Stuckle on Thu, 07 October 2010 03:13
		Re: Send .csv file to browser By: Jerry Stuckle on Wed, 06 October 2010 00:18
		Re: Send .csv file to browser By: Jerry Stuckle on Wed, 06 October 2010 00:21
		Re: Send .csv file to browser By: sheldonlg on Tue, 05 October 2010 18:02
		Re: Send .csv file to browser By: Captain Paralytic on Wed, 06 October 2010 09:01
		Re: Send .csv file to browser By: C. (http://symcbean.b on Tue, 05 October 2010 15:14
		Re: Send .csv file to browser By: Michael on Tue, 05 October 2010 15:20
		Re: Send .csv file to browser By: Peter H. Coffin on Tue, 05 October 2010 15:25
		Re: Send .csv file to browser By: PlastiqueMAN on Tue, 05 October 2010 15:44
		Re: Send .csv file to browser By: PlastiqueMAN on Tue, 05 October 2010 15:55
		Re: Send .csv file to browser By: alvaro.NOSPAMTHANX on Wed, 06 October 2010 14:42
		Re: Send .csv file to browser By: The Natural Philosoph on Wed, 06 October 2010 15:26
		Re: Send .csv file to browser By: Jerry Stuckle on Wed, 06 October 2010 16:36
		Re: Send .csv file to browser By: sheldonlg on Wed, 06 October 2010 17:52
		Re: Send .csv file to browser By: Jerry Stuckle on Wed, 06 October 2010 18:06
		Re: Send .csv file to browser By: Derek Turner on Thu, 07 October 2010 10:25
		Re: Send .csv file to browser By: Derek Turner on Thu, 07 October 2010 12:08
		Re: Send .csv file to browser By: alvaro.NOSPAMTHANX on Thu, 07 October 2010 12:19
		Re: Send .csv file to browser By: sheldonlg on Thu, 07 October 2010 12:41
		Re: Send .csv file to browser By: Jerry Stuckle on Thu, 07 October 2010 12:49
		Send .csv file to browser - Thanks By: Derek Turner on Sat, 09 October 2010 14:30
		Re: Send .csv file to browser - Thanks By: sheldonlg on Sat, 09 October 2010 15:11

Previous Topic:	file access permission?
Next Topic:	Process queue without cron jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 16:24:08 GMT 2024

Total time taken to generate the page: 0.04754 seconds