Jump to content
Larry Ullman's Book Forums

Exporting Table Contents To A Csv File

Recommended Posts

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?


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;

Link to comment
Share on other sites


  • Create New...