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 #170014 is a reply to message #170005]

Tue, 05 October 2010 16:05

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 10/5/2010 10:55 AM, sheldonlg wrote:
> On 10/5/2010 10:20 AM, Derek Turner wrote:
>> On Tue, 05 Oct 2010 14:19:04 +0000, Derek Turner wrote:
>>
>>
>>>
>>> 3. Use appropriate header files and then readfile()
>>
>> Sorry lines/statements
>
> Why not simply
>
> $theData = getDataFromTableAsArrayOfNonAssociativeArrays();
> foreach ($theData as $rec) {
> $line = implode(',', $rec);
> print $line . '<br>';
> }
>
> The user can then cut and paste it into a file or you can put in code
> for the user to download that piece.
>
> Another approach is to output an Excel file and the user can then output
> from that Excel file to a .csv file.
>
>

Right idea, but some problems. First of all, what happens if a field
contains a comma i.e. "Smith, Jr.". Text fields also need to be
surrounded by double quotes, and any double quotes in the text field
must be doubled to be a valid CSV file. Also, some places use a

Not hard - just a matter of looking at each field, and if it is numeric,
insert it in the stream. If it is text, replace all occurrences of '"'
with '""' and insert it with surrounding quotes. Of course, use commas
to separate the fields.

Then just output directly with the appropriate headers.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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 12:26:01 GMT 2024

Total time taken to generate the page: 0.03598 seconds