I have a blob in the database. I want to open a file=BLOB in the browser such
a way as if I clicked on a link. So if it is pdf, its opened by pdf plugin,
if it is doc, it is open by word plugin, if it is zip the dialog for
opening/saving to disk is opened, if it is jpeg it is directly displayed in
the browser. The header() function with Attachment doesn't work. Any idea how
to achieve this effect without writing the BLOB to a temporary file somewhere
on the disk and opening this file ???
You need to get header() to work. Use header() to deliver the correct
content-type for the file, then echo the $BLOB data. That's it. Show your
code if it's not working.
resulting document shows an icon for non-existent image called
script-name.php with byte size of -1 and dimensions 28x30 pixels (as
seen in properties).
and this is my code :
.... connection to SQL
$query = sprintf("SELECT * FROM external_service ORDER BY
timestamp DESC");
$result = mysql_query($query, $connection);
if(($result) AND (mysql_num_rows($result) != 0)):
$zaznam = mysql_fetch_array($result);
$date = $zaznam[0];
$pic = $zaznam[4];
$type = $zaznam[1];
$size = $zaznam[2];
$name = $zaznam[3];
header("Content-Type: $type");
header("Content-length: $size");
header("Content-Disposition: attachement; filename=$name");
header("Content-Description: PHP Generated Data");
echo $pic;
.....