PHP MySQL Export data to excel

Question

I have the following code to export the data from the table that the user choose, but for some reason it's not downloading the file..
here's my export.php:

<?php  
//export.php  
session_start();
$DataDeConsulta = $_SESSION['DataDeConsulta'];
//export.php  
$connect = mysqli_connect("localhost", "user", "pw", "filecleaner");
$output = '';
if(isset($_POST["export"]))
{
 $query = "SELECT * FROM filecleaner.`Opened_". $DataDeConsulta ."`";
 $result = mysqli_query($connect, $query);
 if(mysqli_num_rows($result) > 0)
 {
  $output .= '
   <table class="table" bordered="1">  
                    <tr>  
                         <th>Emails</th>  
                    </tr>
  ';
  while($row = mysqli_fetch_array($result))
  {
   $output .= '
    <tr>  
                         <td>'.$row["Emails"].'</td>  
                    </tr>
   ';
  }
  $output .= '</table>';
  header('Content-Type: application/xls');
  header('Content-Disposition: attachment; filename=download.xls');
  echo $output;
 }
}
?>

And on my index.php I have this:

<form method="post" action="export.php">
     <input type="submit" name="export" class="btn btn-success" value="Export" />
    </form>

It doesn't give me any error at all, just stay where it was and don't download anything

it will not show any error messages because it is in another file — xmaster
– xmaster, Commented Mar 19, 2019 at 12:13
why is the second if mysqli_num_rows and not mysqli_fetch_array? — xmaster
– xmaster, Commented Mar 19, 2019 at 12:20
Comment out the headers, and see what happens then. Or check the request in your browser dev tools, network panel. — 04FS
– 04FS, Commented Mar 19, 2019 at 12:21

Mig · Accepted Answer · 2019-03-19 12:25:11Z

1

Solved. :)

<?php  
//export.php  

session_start();
$DataDeConsulta = $_SESSION['DataDeConsulta'];

//export.php  
$connect = mysqli_connect("localhost", "user", "pw", "filecleaner");
$output = '';

 $query = "SELECT * FROM filecleaner.`Opened_". $DataDeConsulta ."`";
 $result = mysqli_query($connect, $query);
 if(mysqli_num_rows($result) > 0)
 {
  $output .= '
            Emails
  ';
  while($row = mysqli_fetch_array($result))
  {
    $output .= ''.$row["Emails"].'
    ';
  }
  header('Content-Type: application/csv');
  header("Content-Type: application/force-download");
  header('Content-Disposition: attachment; filename=ics2019.csv');
  //
  echo $output;
 }

?>

answered Mar 19, 2019 at 12:25

Mig

596 bronze badges

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

Comments

mani · Accepted Answer · 2019-03-19 12:12:11Z

0

Try This code

<?php  
ob_start();

---
---- 
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=members".date('d-m-Y').".csv");
echo $output;
ob_end_flush();
?>

answered Mar 19, 2019 at 12:12

mani

114 bronze badges

1 Comment

Mig Over a year ago

It happens the same :/

Korat Prakash · Accepted Answer · 2019-03-19 12:41:47Z

0

Try header code into top of the file and remove from bottom.

// The function header by sending raw excel
header("Content-type: application/vnd-ms-excel");
// Defines the name of the export file "download.xls"
header("Content-Disposition: attachment; filename=download.xls");

answered Mar 19, 2019 at 12:41

Korat Prakash

1616 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Export data to excel

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related