php - 使用 PHP 在按下按钮时将 SQL 表导出到 Excel

Question

目的是在单击按钮时将 SQL 表导出到 Excel/CSV 文件。正在执行代码并检索正确的信息，但实际上没有下载任何文件。表中的信息只是以纯格式显示在网页上。

这是按钮的代码(index.php)

<form method="post" action="export.php" class="row">
  <div class="col-6"></div>
  <div class="col-6"><input type="submit" value="Export" name="export" class="button" /></div>
</form>

这是单击按钮时执行的代码(export.php)

<?php   
 if(isset($_POST['export']))  
 {  
     session_start();
$room = $_SESSION['roomval'];
      $connect = mysqli_connect("....", ".....", "....", "....");  
      header('Content-Type: text/csv; charset=utf-8');  
      header('Content-Disposition: attachment; filename=data.csv');  
      $output = fopen("php://output", "w");  
      fputcsv($output, array('ID', 'Firstname', 'Lastname', 'Email', 'SID', 'Room'));  
      $query = "SELECT * from room WHERE room = ('$room') ORDER BY id DESC";  
      $result = mysqli_query($connect, $query);  
      while($row = mysqli_fetch_assoc($result))  
      {  
           fputcsv($output, $row);  
      }  
      fclose($output);  
 }  
 ?>

Answer 1

尝试使用以下 header :

header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=data.csv');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');

来自http://php.net/manual/en/function.readfile.php