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 #170012 is a reply to message #170003]

Tue, 05 October 2010 15:44

PlastiqueMAN
Messages: 5
Registered: September 2010

Karma:

Junior Member

On 2010-10-05 16:19:04 +0200, Derek Turner said:

> 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

You should avoid using temp files for this. Unless the file never
changes, then just upload the file and use readfile() or what ever.

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

If TB sais so, then you probably need to include it. I'd check out the
vcard rfc if I where you.
http://www.ietf.org/rfc/rfc2426.txt

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

probably not...

>
> </OT>
>
> tia
>
> Derek

I'd do something like:

// not tested

$query = "SELECT whatever FROM table WHERE whatever = something;";

$pdo = new PDO( /* connection stuff*/ );
$stm = $pdo->query($query, PDO::FETCH_ASSOC);

header('Content-Type: text/csv; charset=UTF-8'); // replace UTF-8 with
whatever charset you use
header('Content-Disposition: attachment; filename=mycsvfile.csv');

foreach ($stm->fetchAll() as $csv_line)
{
echo implode(',' $csv_line) . "\r\n";
}

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 11:44:07 GMT 2024

Total time taken to generate the page: 0.04961 seconds