Excel export problem in IE

Hi,
I have this script to export mysql data to excel. I have tried
everything but I am not able to get this script to work for IE. The
script downloads the data using Mozilla or Netscape but it fails and
says

Internet Explorer cannot download export.php from "IP Address" (this is

the IP on which the file resides). Internet Explorer was not able to
open this Internet site. The requested site is either unavailable or
cannot be found. Please try again later.


If I remove the header("Content-type: application/vnd.ms-excel;
name='excel'"); then it outputs the database values on the page even
using IE . Not sure what is wrong with the script.


<?php
header("Content-type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: filename=export.xls");
header("Pragma: no-cache");
header("Expires: 0");


require_once("${HTTP_SERVER_VARS['DOCUMENT_ROOT']}/conf/config.ph");



$query = "Select * from table";
$result = mysql_query($query) or die (mysql_error());
$fields=mysql_num_fields($result);
for ($i=0;i<$fields;$++i)
{
$header .= mysql_field_name($result,$i) . "\t";
}
while($row = mysql_fetch_row($result))
{
$line = '';
$count=0;
foreach($row as $value)
{
if ($count ==15)
{
if ($value == 1)
{ $line .= "Yes" . "\t";}
else
{ $line .="No" . "\t"; }
}
else
{
if((!isset($value) OR ($value==""))
{
$value = "\t";
}
else
{
$value = str_replace('"', '""', $value);
$value = '"' . stripslashes($value) . '"'
.. "\t";
}
$line .= $value;
}
$count ++;
}
$data . =trim($line) . "\n";
}
$data = str_replace("\r", " ", $data);
if ($data=="")
{
$data = "\n No records found\n";


}
echo "$header\n$data\n";
mysql_free_result($result);
?>


This is the whole script. Not sure if the script is wrong somewhere or
what.
Any help is appreciated
Thanks
Subrato

.

Relevant Pages

  • Re: Excel export problem in IE
    ... I have this script to export mysql data to excel. ... Internet Explorer cannot download export.php from "IP Address" (this is ... open this Internet site. ... or/and NetScape. ...
    (alt.php)
  • Re: Proxying a FLV file
    ... of each and see if your script has introduced any differences between them. ... IE throws an error box window saying "Internet Explorer cannot ... able to open this Internet site - the site is either unavailable or ... but I don't fancy sticking 1.7gb of flv's into a DB! ...
    (comp.lang.php)
  • RE: [PHP] php mysql live feed
    ... You would want to add a script somewhere that would begin the interval in order to update the div: ... [PHP] php mysql live feed ... I am trying to use php to pull mysql data and refresh the mysql data ... I want the data to refresh but not the screen. ...
    (php.general)
  • Re: Excel export problem
    ... excel, or excel has to be already open for it to open from the link. ... I have this script to export mysql data to excel. ... Internet Explorer cannot download export.php from "IP Address" (this is ... open this Internet site. ...
    (php.general)
  • Re: Excel export problem
    ... excel, or excel has to be already open for it to open from the link. ... I have this script to export mysql data to excel. ... Internet Explorer cannot download export.php from "IP Address" (this is ... open this Internet site. ...
    (php.general)