Page 1 of 1

Exporting oracle query results to CSV using PHP

Posted: Tue Jun 17, 2008 12:43 pm
by srirams
Hi,

I am trying to export the results of an oracle query into a CSV file and downloadable from a browser using PHP code.
I have seen many sample codes for mysql.

Can someone paste an example code to perform the above.

Regards
Sriram.S

Re: Exporting oracle query results to CSV using PHP

Posted: Tue Jun 17, 2008 1:35 pm
by WebbieDave
No code from me but I can point you in the right direction.

Here's an RFC for csv
http://tools.ietf.org/html/rfc4180

Here's a quicker explanation of the csv format:
http://en.wikipedia.org/wiki/Comma-separated_values

Here's a link to PHP's oracle docs
http://us.php.net/oracle

Here's one to Oracle's PHP Dev Center:
http://www.oracle.com/technology/tech/php/index.html

You could probably find free code to do the required functionality with minor modifications on google.