Re: dump data, and save as a file

From: Date: Sat, 15 Feb 2003 00:07:52 +0000
Subject: Re: dump data, and save as a file
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-25648@lists.php.net to get a copy of this message
Use Content-Type: application/octet-stream Gary Every <Gary.Every@ingramentertainment.com> wrote: > Header("Content-type: text/plain"); > Header("Content-Disposition: attachment; filename=topsellers_dvd.csv"); > Gary Every > Sr. UNIX Administrator > Ingram Entertainment > (615) 287-4876 > "Pay It Forward" > mailto:gary.every@ingramentertainment.com > http://accessingram.com > 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

« previous php.db (#25648) next »