Downlaodabe Export .csv

[GD77]

$file = 'export';
$tbl="tbl_xxx";
$qry_expEm = mysql_query("SHOW COLUMNS FROM `".$tbl."`");
$i = 0;
if (mysql_num_rows($qry_expEm) > 0) {
while ($row = mysql_fetch_assoc($qry_expEm)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";
$values = mysql_query("SELECT * FROM `".$tbl."`");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "\n";
}
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;

 

using this common script why does it output all HTML codes of the current page?

[smoseley]

That script should not be placed inside a page. It should be its own PHP script (e.g. csv.php), which you would link to from another page.

[GD77]

Thank you very much.