Re: dump data, and save as a file
| From: | Stephane | Date: | Fri, 14 Feb 2003 14:58:07 +0000 |
| Subject: | Re: dump data, and save as a file | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25633@lists.php.net to get a copy of this message | ||
On Fri, 2003-02-14 at 03:09, Ruth Zhai wrote:
> Hi everyone,
> I want to dump some data from mysql into a file, and use php to force the browser to pop a
> download file window. This seems a simple procedure, but I am having trouble to make it work with
> IE. The following is what I did:
>
> ********************************
> ob_start();
> $query = "SELECT * FROM table";
> $result=mysql_query($query);
> while($row=mysql_fetch_array($result))
> {
> echo $row['data'];
> }
> header("Cache-control: private");
> header("Content-Type: application/txt");
> header("Content-Disposition: attachment; filename=test.txt);
Did you try with header("Content-Type: application/octet-stream");
header("Content-transfer-encoding: binary\n");
?
>
> //Note: I also tried: header("Content-Disposition: inline; filename=test.txt);
>
> ob_end_flush();
> *********************************
>
> It seems OK with Netscape, but with IE, all I got is all data displayed on the screen even with
> ob_start(). I also tried "echo" the data after "header()", I have the same
> result. I have spent a long time on this, and searched for information on www.php.net, but can not
> find an answer. Your help is highly appreciated.
>
> Thanks in advance.
>
> Ruth
--
Stephane <anselme@netcourrier.com>