Exporting SQL table to Excel on button press using PHP

Question

The aim is to export an SQL table to Excel/CSV file when a button is clicked. The code is being executed and the correct information is being retrieved but no file is actually being downloaded. The Information from the table is just being displayed on a web page in a plain format.

Here is the code for the button (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>

Here is the code which is being executed when the button is clicked (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);  
 }  
 ?>

Phil · Accepted Answer · 2018-03-02 23:18:46Z

2

Try using the following headers:

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');

From http://php.net/manual/en/function.readfile.php

answered Mar 2, 2018 at 23:18

Phil

2722 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting SQL table to Excel on button press using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related