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 #170026 is a reply to message #170021]

Wed, 06 October 2010 03:50

Adam Harvey
Messages: 25
Registered: September 2010

Karma:

Junior Member

On Tue, 05 Oct 2010 14:06:45 -0400, sheldonlg wrote:
> On 10/5/2010 12:52 PM, Derek Turner wrote:
>> When TB exports a csv it doesn't quote text fields so presumably it
>> doesn't need them quoted to import them:
>
> What if I have in there that my nickname is Shelly ("sheldonlg")? How
> does the db have the " in the table? How is that retrieved? How does
> that appear when written to the browser? What if single quotes are used
> as in O'Reilly? That is what Jerry is talking about. You always have
> to be concerned with things like this.

Indeed, which is why I'd go with the built-in fputcsv() function which
should do sensible things with quoting; ie something like this:

// fputcsv() can only write to a file/stream handle, so let's open one up.
$fp = fopen('php://temp', 'r+');

// Loop over the data using whatever the appropriate database function is.
// We'll assume $rs is a MySQL result resource, but it doesn't really
// matter where it comes from.
while ($row = mysql_fetch_array($rs)) {
fputcsv($fp, $rec);
}

// Rewind the stream handle and actually output the CSV data.
// No temporary file required!
header('Content-Type: text/csv');
rewind($fp);
fpassthru($fp);
fclose($fp);

Adam

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: Wed Nov 27 15:41:05 GMT 2024

Total time taken to generate the page: 0.04931 seconds