Export into CSV from website

[jfontein]

Hello,

I am displaying a membership list from a MySQL database on a webpage.
I inlcuded a button at the bottom so the members can export the whole membership list into .csv. This button (submit_export) then should generate a pop-up to "open or save" the file, just like it works in PHP-MyAdmin. I tried something like this, bus doesn't work. Any help?

if ($_POST['submit_insert']){
    header('location: edit_contact_info.php?type=new');
    exit();
}elseif ($_POST['submit_export']){
   mysql_query("SELECT * INTO OUTFILE '/membership.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM ($tbl_users)");
}

(PS: $tbl_users specifies the table name, which is put in a variable)

[beefy23]

If you running this on a windows platform, be aware of the following:

The \' pathname separator character
Pathname components in Windows are separated by the\' character, which is also the escape character in MySQL. If you are using LOAD DATA INFILE or SELECT ... INTO OUTFILE, use Unix-style filenames with `/' characters:

mysql> LOAD DATA INFILE 'C:/tmp/skr.txt' INTO TABLE skr;
mysql> SELECT * INTO OUTFILE 'C:/tmp/skr.txt' FROM skr;

Alternatively, you must double the `\' character:

mysql> LOAD DATA INFILE 'C:\\tmp\\skr.txt' INTO TABLE skr;
mysql> SELECT * INTO OUTFILE 'C:\\tmp\\skr.txt' FROM skr;

If on the other hand you're running this on '733t' 7inux, then the file path may need to be specified as the user's current directory. Your current query looks as though it might be trying to write to the root '/' which ordinarily you should not have access to.