php - 从 PHP 服务器下载 csv 文件

Question

我正在编写代码以将查询输出保存在 csv 文件中。它被保存在服务器上的 csv 文件中。但是如何在单击按钮时从服务器下载该文件。我写了下面的代码，但它没有下载你的文件。谁能帮帮我。

代码:-

$group_result = mysql_query($selectquery, $conn);                                                   
$fp = fopen('books.csv', 'w');
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="books.csv"');
$filename = 'books.csv';
while ($container_id_record = mysql_fetch_assoc($group_result)) {
$i++;

echo"<tr class='gradeA odd' role='row'><td class='sorting_1'>" . $container_id_record['enquiry_date'] . "</td><td>" . $container_id_record['name'] . "</td><td>" .$container_id_record['mobile']. "</td><td>" . $container_id_record['program_name'] .  "</td><td>" . $container_id_record['schedule'] .  "</td><td>" . $container_id_record['shift'] .  "</td><td>" . $container_id_record['remark'] .  "</td>";

fputcsv($fp, $container_id_record);


}

fclose($fp);
readfile($filename);

Answer 1

在 php 中生成 csv 文件的最佳方法

<?php 
$list = array (
array('aaa', 'b,bb', 'cc\c', 'ddd/d'),
array('123', '45,6', '789'),
array('"aaa"', '"bbb"'));
$fp = fopen('file.csv', 'w+');
foreach ($list as $fields) {
    fputcsv($fp, $fields);
}
fclose($fp);
?>

<a href="file.csv">Download File</a>