dump data, and save as a file
| From: | Ruth Zhai | Date: | Fri, 14 Feb 2003 02:09:19 +0000 |
| Subject: | dump data, and save as a file | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25625@lists.php.net to get a copy of this message | ||
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);
//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