在php中导出csv文件时出现问题

Question

当我像这样导出文件名"yourfilename.csv_“时，我需要用mysql查询.But在php中导出csv文件。

我的代码是

header("Content-type: application/csv");

header("Content-Disposition: \"inline; filename=yourfilename.csv\"");  

$query = "SELECT * FROM login";

$result = mysql_query($query) ;

echo "username ,password \r\n";

while($row = mysql_fetch_array($result))
{
    echo "$row[user],$row[pass]\r\n";  
}  

我需要文件名"yourfilename.csv“。

Answer 1

您可以使用以下命令让MySql直接将查询结果返回到文件

SELECT * INTO OUTFILE 'result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM my_table;

然后就这样做(also see Example #1 Download dialog)

header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="yourfilename.csv"');
readfile('result.csv');