无法让 PHP 将 CSV 下载给用户

Question

当我使用此代码将内容下载到 CSV 文件和用户时，它只是显示对网站的查询......

$result = $conn->query($sql);
if (mysqli_num_rows($result) > 0) {
$counter=1;
// open file and put herder to csv file
$file = fopen('php://output', 'w');
fputcsv($file, array('id','name','test1','test2'));
// put content to csv file
while ($row = mysqli_fetch_assoc($result)) {
    fputcsv($file, array($counter++,$row['name'],
                         ($row['test1']!=-1)?$row['test1']:'null',($row['test2']!=-1)?$row['test2']:'null'));
}
$csv_name=(isset($_GET['device'])&&$_GET['device']!='')?$_GET['device']:"all_devices";
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment;'.
       'filename='.$csv_name.'_'.date('Y-m-d').'.csv');
} else {
  echo "No device found";
}

Answer 1

通过在fputcsv()前面移动header()调用，您可以使用输出缓冲来绕过脚本，方法是在脚本的开头调用ob_start()，在脚本结束时调用ob_end_flush()。