Trying to create a csv file from a table using php

Jemm

Hi there,

I am trying to allow users download a csv file from my website. This is as far as I have got with the code but it just opens a blank page and doesn't download anything.


Any advice?
[PHP]

<?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."</td>";
$html .= "</tr>";}$html .= "</table>";
header("Content-Type: text/csv");
header("Content-Disposition: attachment;filename=yourfile.csv");
echo $html;
?>[/PHP]

komodosp

Not sure but my first guess might be that a CSV file is a comma delimited file, whereas you seem to be sending a html table...

In any case, in PHP a blank page often means a syntax error or something if the error reporting is turned off. Have you tried putting this code at the top of your program:

display_errors(1);
error_reporting(E_ALL);

Actually I have just noticed that before you open your <?php there's a blank line and then a space - is this in your program too or did it just happen when copying and pasting? - this would cause an error as your headers have already been sent by the time you get to

header("Content-Type: text/csv");

- If you're going to use the header() function, <?php must be the very first thing in your program, and no output sent before you use header()..