Jump to content

Download images (not just display them on a web page) from Blob


moshy

Recommended Posts

I have stored images on mysql using blob. I want to download the images back to my computer in their original format (Not just displaying them on the web page). How do I do this ? The script for displaying the images on the web page is shown below. How can I modify this code to directly download the images back to my computer ?

 

<?php
$link=mysql_connect("localhost","root","");
if(!$link)
{
  die("could not connect:".mysql_error());
}
mysql_select_db("media",$link);
$que="select imageBlob from images where imageId=10"; //imageBlob- name of the blob data type field in mysql.
$ret=mysql_query($que)or die("Invalid query: " . mysql_error());
header("Content-type: image/jpeg");
echo mysql_result($ret, 0);
mysql_close($link);
?>

Link to comment
Share on other sites

You should use the force http header commend for content disposition

 

<?php
$link=mysql_connect("localhost","root","");
if(!$link)
   {
      die("could not connect:".mysql_error());
   }
   mysql_select_db("media",$link);
   $que="select imageBlob from images where imageId=10";
   $ret=mysql_query($que)or die("Invalid query: " . mysql_error());
   $data = mysql_result($ret, 0);
   header("Content-type: image/jpeg");
   header('Content-Disposition: attachment; filename="image.jpg"');
   header('Content-Length: '.strlen($data));

   echo $data;
   mysql_close($link);
?>

 

should work fine

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...