Exporting Table Contents To A Csv File

[jemmm 0]

Hi there,

 

I am trying to allow users download a csv file from my website. This is the code I've been trying to use but it just opens a blank page and doesn't download anything. Any advice?

 

<?php
require_once (MYSQL);
require_once ('mysqli_connect.php');


$q="SELECT * FROM table_name";
$r = @mysqli_query($dbc, $q);
$html = "<table>";
$html .= "<tr><td>Song</td>";

$html .= "</tr>";
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC))  {
$html .= "<tr><td>".$row['music_song']."</td>";
$html .= "</tr>";
}
$html .= "</table>";
header("Content-Type: text/csv");
header("Content-Disposition: attachment;filename=yourfile.csv");
echo $html;
?>

[jemmm 0]

I've fixed it

[Larry 433]

Kudos for fixing it. In the future, could you post your fix/solution, too, so that others might benefit? And, per the forum rules, please include your details such as the PHP and MySQL version.