|
|
Posted by Patrick Buxton on 09/28/80 11:48
Sorry, should have clarified, the output is just output to the browser as
text
"Patrick Buxton" <patrick.buxton@redrow.co.uk> wrote in message
news:JNGdnQNpWbxM-O7ZRVnyiw@pipex.net...
> 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]
|