Comments on snippet: 'Export MySQL query results to CSV'

ajaypillarisetti said on 9/8/09

Tue, 08 Sep 2009 18:54:45 GMT

i'm kinda new to php. i help run a competition with teams from schools all over the country. i've got a page that allows a user to select a variable [a specific school, in this case] from a dropdown. this variable is then part of a query that returns some results specific information about the number of teams from the selected school and outputs them to a table. I'd like to be able to export that same query to csv. Do you all have any thoughts on how I could do that? Thanks much.

ajaypillarisetti said on 9/8/09

Tue, 08 Sep 2009 18:54:07 GMT

stephenwashburn said on 8/31/09

Mon, 31 Aug 2009 20:01:29 GMT

@killy, if you want the results to be on the server instead of sent to the client you will want to use fopen() and fwrite() in order to write the contents to a local file (obviously the file/folder will need to be writable by whatever user you are running php as - I believe its generally the apache user, depending on your setup of course).

killy said on 8/31/09

Mon, 31 Aug 2009 00:20:27 GMT

how to make exported stay on server??

nevbear666 said on 1/14/09

Wed, 14 Jan 2009 02:28:28 GMT

mysql_list_fields is deprecated... i used this one instead: [code] mysql_query("SELECT fieldname1,fieldname2,fieldname3...,fieldnameN FROM table_name"); [/code]

tylerhall said on 3/1/07

Thu, 01 Mar 2007 12:05:26 GMT

In some situations it might also be useful to force the user's browser to download the file. Adding these lines should do the trick.

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Disposition: attachment; filename = $filename");
header("Content-Length: " . strlen($out));