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 #170041 is a reply to message #170040]

Wed, 06 October 2010 17:52

sheldonlg
Messages: 166
Registered: September 2010

Karma:

Senior Member

On 10/6/2010 12:36 PM, Jerry Stuckle wrote:
> On 10/5/2010 10:19 AM, 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
>>
>> 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
>
> OK, since no one else posted it and I have some time:
>
> $sql = 'query here'';
> result = mysql_query($sql);
> if ($result) {
> $outfile = fopen('php://output', 'w');
> header('Content-Type: text/csv');
> header('Content-disposition: attachment; filename=data.csv');
> while ($row = mysql_fetch_array($rsc)) {
> fputcsv($outfile, $row);
> }
> fclose($outfile);
> }
>

Two errors that immediately pop up.

Your second line is missing the dollar sign.
Your mysql_fetch_array uses $rsc, not $result.

Also, I posted something similar where I used $rsc.

--
Shelly

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:46:43 GMT 2024

Total time taken to generate the page: 0.04460 seconds