PHP - Header() Download File Help

I put this in the wrong forum and copied it to this one. I apologize ahead of time for the double post.

(quote author=radi8 link=topic=333351.msg1569942#msg1569942 date=1305654626)
One more question for you all:

We just installed a new Linux Ubuntu V 11.04 server with LAMP (Apache2, PHP 5.3.x, MySQL 5.1.4, etc...) all out of the box stuff.

I developed (locally) and app where I am exporting some data from MySQL, putting it into a spreadsheet and then sending the Excel file to the client. This all worked fine in my dev setup. BUT... (you know whats coming next) after deploying the app to the new Web Server, when I attempt to export the data, I am successfully creating the Excel file but rather than opening the download dialogue box, the data is being read and sent to the browser window as text!

As I mentioned before, this is a new web server, so there may be something missing on the Apache2 setup, or my code may just be crap. Either way, my head hurts and cannot find out what is happening.

Here is my header type configuration:
Code: [Select]
<?php
function save($filename, $download=false, $download_filename="")
    {
        if (!$download)
        {
            return $this->domXML->save($filename);
        }
        elseif ($this->domXML->save($filename))
        {
            $realFileInfo = $_SERVER['DOCUMENT_ROOT'].'/truck/admin/export/'.$download_filename; 
            $FileInfo = pathinfo($filename);
            ob_end_clean();
            // fix for IE catching or PHP bug issue 
            header("Pragma: public"); 
            header("Expires: 0"); // set expiration time 
            header('Last-Modified: '.gmdate('D, d M Y H:i:s') . ' GMT'); 
            header('Cache-Control: no-store, no-cache, must-revalidate');     // HTTP/1.1
            header('Cache-Control: pre-check=0, post-check=0, max-age=0');    // HTTP/1.1
            header ("Pragma: no-cache"); 
            //header("Cache-Control: must-revalidate, post-check=0, pre-check=0");  
            
            // browser must download file from server instead of cache 
            // force download dialog 
            header("Content-Type: application/force-download"); 
            header("Content-Type: application/octet-stream");
            header('Content-Type: application/vnd.ms-excel;');                 // This should work for IE & Opera  
            header("Content-type: application/x-msexcel");
            header("Content-Type: application/download"); 
            
            // use the Content-Disposition header to supply a recommended filename and  
            // force the browser to display the save dialog.
            if ($download_filename == "")$download_filename = "download.xls";
            //header("Content-Disposition: attachment; filename=".$download_filename.";"); 
            header("Content-Disposition: attachment; filename=".$realFileInfo.";"); 
            header("Content-Transfer-Encoding: binary");
            //header("Content-Length: ".filesize($filename)); 
            header("Content-Length: ".filesize($realFileInfo)); 
            
            //@readfile($filename);
            @readfile($realFileInfo);
            return true;
        }
        return false;
    }
?>

I added a screen cap for you to see the output. Can you see anything wrong?

I have a small program that is to be used to export data from some MYSQL tables into an Excel spreadsheet.

It does the export successfully, the first pass, but each subsequent download selection causes the browser to display the html code as text to the browser.

If I disable the excel output, the page redraws successfully un subsequent requests.

The header definition I have is ias follows:
Code: [Select]
$FileInfo = pathinfo(filename);
            // fix for IE catching or PHP bug issue
           
            header("Pragma: public");
            header("Expires: 0"); // set expiration time
            header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
            // browser must download file from server instead of cache
            // force download dialog
            header("Content-Type: application/force-download");
            header("Content-Type: application/octet-stream");
            header("Content-type: application/x-msexcel");
            header("Content-Type: application/download");
            // use the Content-Disposition header to supply a recommended filename and 
            // force the browser to display the save dialog.
            if ($download_filename == "")
                $download_filename = "download.xlm";
            header("Content-Disposition: attachment; filename=".$download_filename.";");
            header("Content-Transfer-Encoding: binary");
            header("Content-Length: ".filesize($filename));
            @readfile($filename);

I did not setup this header, because to be honest, these things confuse the heck out of me. Can anyone see what may be wrong with this? Can you give me some suggestions?

I can post more of the code if needed, but i believe that this is the area of interest for this issue.

Thanks in advance.

go on with the title, i mean, when i click the download button and it starts downloading, i can't refresh the page or go to other adress of my site,  it will really  take a long time. the header information is something like this  (except some judgement)
    header("Content-Disposition: attachment; filename=" . $name);   
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");
    header("Content-Description: File Transfer");             
    header("Content-Length: " . filesize($adress));
    flush(); // this doesn't really matter.

    $fp = fopen($adress, "r");
    while (!feof($fp))
    {
      echo fread($fp, 65536);
      flush(); // this is essential for large downloads
    } 
    fclose($fp);

it takes me days but i cant find any way...thanks a lot!!! thanks a lot!!! thanks a lot!!!

All,
I found the following script to do the download:

   $resultsetpic = mysql_fetch_array($resultpic); 
   $filename = "full_size/$resultsetpic[filename]"; // don't accept other directories 
   $size = @getimagesize($filename); 
   $fp = @fopen($filename, "rb"); 
   if ($size && $fp) 
   { 
      header("Content-type: {$size['mime']}"); 
      header("Content-Length: " . filesize($filename)); 
      header("Content-Disposition: attachment; filename=$filename"); 
      header('Content-Transfer-Encoding: binary'); 
      header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); 
      fpassthru($fp); 
      exit; 
   }

This downloads the file fine. However what I would like to do is also refresh the page that the user was just on. So I tried to add this:

   $resultsetpic = mysql_fetch_array($resultpic); 
   $filename = "full_size/$resultsetpic[filename]"; // don't accept other directories 
   $size = @getimagesize($filename); 
   $fp = @fopen($filename, "rb"); 
   if ($size && $fp) 
   { 
      header("Content-type: {$size['mime']}"); 
      header("Content-Length: " . filesize($filename)); 
      header("Content-Disposition: attachment; filename=$filename"); 
      header('Content-Transfer-Encoding: binary'); 
      header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); 
      fpassthru($fp); 
      exit; 
   } 
         $target = "work_queue.php"; 
      header("Location:". $target); 

However, this doesn't reload the page they were on. Any ideas on how to do this? Thanks in advance.

Hello I already know this is possible with php


<?php
$file = 'monkey.gif';

if (file_exists($file)) {
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename='.basename($file));
    header('Content-Transfer-Encoding: binary');
    header('Expires: 0');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    header('Content-Length: ' . filesize($file));
    ob_clean();
    flush();
    readfile($file);
    exit;
}
?>


But I am wondering is it possible to just send over a string of data stored in like $data and create a file clientside (nothing server side).

So i'm guessing readfile() has to be replaced with something