Binary Data Ouput

TOrpheus

Hi All,

I've written a script that will output binary data that is stored in the database.

I've used the script on 2 different servers. It works fine one one, but when I use it on the other server, it doesn't work.

I'm uploading binary files (.doc, .xls, .jpg. etc...)

When I click on the link the calls the script that will "retreive" the files, I get an error.

On the server that it works, the link will prompt me to save the "file.doc".

On the OTHER server, it will prompt me to save but it says "www.site.com/file.php?fileID=5" basically the link refernce, and NOT the actual file name reference.

Can you see what's up??

** The script that I use to store the data, splits the data in chunks to alleviate any stress of downloading a 10 MB file from ONE record in the database (I read somewhere that was the best solution) Again, this script works on ONE server, but not the other...

Here's teh script that outputs...

header("Content-Type: $fileDataType");
header("Content-Length: $fileSize");
header("Content-Disposition: attachment; filename=$filename");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: public");

$q = "SELECT * FROM SS_RoleFileData WHERE ssRoleID='$ssRoleID' ORDER BY ssRoleFileDataID";
$r = mysql_query($q);
while ($ra = mysql_fetch_array($r)) {
echo $ra[fileData];
}

weekender

surely if your using output from the db in the header, then the header needs to be inside the loop which reads the record...

$q = "SELECT * FROM SS_RoleFileData WHERE ssRoleID='$ssRoleID' ORDER BY ssRoleFileDataID"; 
$r = mysql_query($q); 
while ($ra = mysql_fetch_array($r)) { 
header("Content-Type: $fileDataType"); 
header("Content-Length: $fileSize"); 
header("Content-Disposition: attachment; filename=$filename"); 
header("Expires: 0"); 
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Pragma: public"); 
echo $ra[fileData]; 
}

TOrpheus

Hi Weekender,

Nope... your solution would not work... there would never be a situation where you woudl put "header()" function calls inside a LOOP!

As I mentioned in my original post, my solution works on one server and not the other. And the way the input is taken in, the data is broken into pieces.. so that's why I have the loop to go through a table.

So basically you can disregard the loop all together, and the code still is giving me that problem with saving/opening file...

The correct solution would be the browser asking me to save "file.doc".

The in-correct solution I'm getting is that it is asking me to save file.php?fileID=5.. then IE crashes or says cannot find server...

Thanks for the help tho...!

weekender

Originally posted by TOrpheus
there would never be a situation where you woudl put "header()" function calls inside a LOOP!

yeah i know, but there is also no situation where you would download more than one file in one attempt - so really none of it should be in a loop, so take the loop out altogether.

TOrpheus

Hi there,

When storing LARGE files... let's say 10 MB... you wouldn't want to store ALL 10 MB of data in ONE record in teh table.

You want to break that data up into smaller chunks so reading from the database would be better.

My original problem is still not solved... Anybody have any solution????