Output as csv

[Geoff Berrow]

I'm trying to output the results of a database query as a csv file

The DB output is in $csv

foreach($csv as $array){
$line[]=implode($delimited_by,$array)."\n";
}
header("Content-Type: text/plain");
header("Content-Disposition: inline");

foreach($line as $output){
print $output;
On clicking the link to this file the results are output to the screen.
I can right click and save the output but I'm prompted to save it as a
..php file. How can I make it output as the right kind ( .csv) of file?

--
Regards,

Geoff Berrow

[Bent Stigsen]

Geoff Berrow wrote:

I'm trying to output the results of a database query as a csv file

The DB output is in $csv

foreach($csv as $array){
$line[]=implode($delimited_by,$array)."\n";
}
header("Content-Type: text/plain");
header("Content-Disposition: inline");

foreach($line as $output){
print $output;
On clicking the link to this file the results are output to the screen.
I can right click and save the output but I'm prompted to save it as a
.php file. How can I make it output as the right kind ( .csv) of file?

There is a rfc stating "text/csv" as the mime-type, but it is quite
recent, so probably not widely recognized.
http://www.rfc-archive.org/getrfc.php?rfc=4180

Presently, I think the common way is to set disposition to attachment
and supply a filename, and let the OS figure out how to open it.
header('Content-Disposition: attachment; filename="foo.csv"');
/Bent

[Geoff Berrow]

Message-ID: <44***********************@dread15.news.tele.dk> from Bent
Stigsen contained the following:

There is a rfc stating "text/csv" as the mime-type, but it is quite
recent, so probably not widely recognized.
http://www.rfc-archive.org/getrfc.php?rfc=4180

Presently, I think the common way is to set disposition to attachment
and supply a filename, and let the OS figure out how to open it.
header('Content-Disposition: attachment; filename="foo.csv"');

Thanks.

I have found that this gives an option to open or dave the file,
however, opening it does not work.

But the following seems to work fine.

header("Content-Type: text/csv");
header("Content-Disposition: inline; filename=$_SESSION[table].csv ");

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Geoff Berrow]

Message-ID: <a7********************************@4ax.com> from Geoff
Berrow contained the following:

header("Content-Type: text/csv");
header("Content-Disposition: inline; filename=$_SESSION[table].csv ");

OK, I'm exporting CSV files nicely now but I wondered how other people
tackle the problem of the content containing quotes.

I'm exporting the data like this

"some data", "some more data", "yet more data"

Eventually the file will be imported into Access.

It occurred to me that if the data contained a double quote mark, then
the file could be messed up.

I've done a string replace and changed double quotes to single, but this
doesn't feel like a very elegant or satisfactory solution so I wondered
what other people do?

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[NC]

Geoff Berrow wrote:

I'm exporting CSV files nicely now but I wondered how other
people tackle the problem of the content containing quotes.

RFC 4180 specifies escaping a double quote by putting another double
quote in front of it. However, RFC 4180's status is "Informational",
and it notes the existence of "considerable differences among
implementations". So you should consult the manual(s) for the software
that you expect to read the CSV you are generating and see what they
suggest.

Cheers,
NC

[Geoff Berrow]

Message-ID: <11*********************@j33g2000cwa.googlegroups. com> from
NC contained the following:

RFC 4180 specifies escaping a double quote by putting another double
quote in front of it. However, RFC 4180's status is "Informational",
and it notes the existence of "considerable differences among
implementations". So you should consult the manual(s) for the software
that you expect to read the CSV you are generating and see what they
suggest.

Thanks, I'll give it a try.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Toby Inkster]

NC wrote:

RFC 4180 specifies escaping a double quote by putting another double
quote in front of it. However, RFC 4180's status is "Informational",
and it notes the existence of "considerable differences among
implementations".

The OP mentioned importing into Access. Access does indeed support this
method of escaping.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

[adrian.price]

If you've got access to PHP 5.1+, you can just use the already
RFC-compliant fputcsv() function:

http://us3.php.net/fputcsv

[shriop]

um, rfc where? there's no stinkin rfc...

ad**********@gmail.com wrote:

If you've got access to PHP 5.1+, you can just use the already
RFC-compliant fputcsv() function:

http://us3.php.net/fputcsv

[shriop]

ignore me. wasn't paying attention to the thread... interesting.

shriop wrote:

um, rfc where? there's no stinkin rfc...

ad**********@gmail.com wrote:

If you've got access to PHP 5.1+, you can just use the already
RFC-compliant fputcsv() function:

http://us3.php.net/fputcsv