|
Posted by Patrick Buxton on 09/28/39 11:48
Hi
I can't seem to get the file download dialog to appear, the code I'm using
is below, any ideas very welcome!!
<?php
include 'config.php';
include 'opendb.php';
$query="select * from atable";
$result = mysql_query($query) or die(mysql_error());
$csv = array();
$html = array();
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
$csv[] = implode(",", $row);
$html[] = "<tr><td>" .implode("</td><td>", $row) . "</td></tr>";
}
$tsv = implode("\r\n", $csv);
$html = "<table>" . implode("\r\n", $html) . "</table>";
$fileName = 'DBDownload.csv';
//header("Content-type: text/plain");
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=$fileName");
print $tsv;
exit;
?>
Thanks in advance
Pat Buxton
Navigation:
[Reply to this message]
|