PHP - Need Help With Download Header

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?

Hello everyone!

 I'm somewhat of a newb in this so anyways I have this script and I try to force a browser to download a file when someone hits a download button.

here is what I'm trying:

   header('Content-Type: application-download');
   header('Content-Disposition: attachment; filename=' .basename($dl_id));
   readfile($dl_id);

It seems to work in Chrome, Firefox, but it doesn't work in IE

Any suggestions?

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.

Basically I would like to place a link on my website and have the user download a file, but rather than just right clicking and choosing save target as, the link must be clicked, on the next page the file is fetched and then the client can download the file. How would I go about setting this up please?

When the download appears the link that is produced doesn't show the actual download either, so users can't leech of it.

Thanks