PHP -导出CSV文件时出错

Question

在PHP中导出CSV文件时，整页代码也会导出，之后只导出数据。

代码：

<?php

      header("Content-type: text/csv");
      header("Content-Disposition: attachment; filename=file.csv");
      header("Pragma: no-cache");
      header("Expires: 0");
      $data = array(
          array("data12", "data16", "data17"),
          array("data2", "data33", "data25"),
          array("data31", "data32", "data23")
      );   
      $file = fopen('php://output', 'w');                              
      fputcsv($file, array('Description', 'Click', 'CTR'));      

?>

​

​

Answer 1

您应该为csv文件准备数据(不要发送数组)。我也不知道你想在csv文件中得到什么结果。

尝尝这个

$data = array(
      array("data12", "data16", "data17"),
      array("data2", "data33", "data25"),
      array("data31", "data32", "data23")
    );
    $csvData = "Your header\n";
    foreach ($data as $row) {
      foreach($row as $dot) {
        $csvData .= $dot.';';
      }
    }
    $csvData = utf8_decode($csvData);
    header('Content-Type: application/csv; charset=UTF-8');
    header('Content-Disposition: attachement; filename="myfile.csv"');
    echo $csvData;
    exit();