Help extracting images please

[mark256]

I am using php 4 and dreamweaver mx, I have successfully inserted an image into my db and have been able to extract it, but my problem is it only displays the raw data and not the image, I am new to php and cannot find a solution on my own. Can anyone please help me................😕

[theeper]

Make an include file that gets the binary data from the table and puts it into a variable. Something like this.

<?
// connect to DB code

$sql = "SELECT * FROM table WHERE id = '" . $_GET['id'] . "'";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result)) {
  header("Content-type: image/pjpeg");
  echo $row['binary_data'];
  }
?>

Pass a variable to it in an IMG SRC tag like this...

<A HREF='imagescript.php?id=10'>

Make sure there is no HTML output before the header line. Probably don't need to use mysql_fetch_array if you only need the binary data. Just get it however you need.

[mark256]

Many many thanx to you Theeper, I had to still do a bit of messing around, but I got there in the end, your script worked and it I am so chuffed, once again many thanx😃

[theeper]

One thing to remember though, it isn't usually a good idea to store images in a database. It is better to keep the images within the filesystem where they belong. Then you just need to store the URL in the DB.