PHP - MySQL query to CSV export

[ElitePirate]

Hi

I need some advise how to achieve this.. there is a link "Click here to generate CSV" when someone clicks that link, it should execute a query and export that sql query result to a CSV file..

any guidance pls?

Sam

ElitePirate Reviewed by ElitePirate on 25th Jul 2012. PHP - MySQL query to CSV export Hi I need some advise how to achieve this.. there is a link "Click here to generate CSV" when someone clicks that link, it should execute a query and export that sql query result to a CSV file.. any guidance pls? Sam Rating: 5

[deliteblogger]

http://lmgtfy.com/?q=php+mysql+to+csv

[jokerhacker]

google says:

mysql_connect($server, $login, $password);
mysql_select_db($db);

$fp = fopen($filename, "w");

$res = mysql_query("SELECT * FROM $table");

// fetch a row and write the column names out to the file
$row = mysql_fetch_assoc($res);
$line = "";
$comma = "";
foreach($row as $name => $value) {
    $line .= $comma . '"' . str_replace('"', '""', $name) . '"';
    $comma = ",";
}
$line .= "\n";
fputs($fp, $line);

// remove the result pointer back to the start
mysql_data_seek($res, 0);

// and loop through the actual data
while($row = mysql_fetch_assoc($res)) {
   
    $line = "";
    $comma = "";
    foreach($row as $value) {
        $line .= $comma . '"' . str_replace('"', '""', $value) . '"';
        $comma = ",";
    }
    $line .= "\n";
    fputs($fp, $line);
   
}

fclose($fp);