Retrieving Images from a MySQL database

[huntrguy102]

I have images stored in a mysql database.  I have it as Type: Blob. It is binary data.

 

my first question is: Did I go about putting the image in right?

 

My second question is: How would I go about retrieving these images from the database?

 

a very detailed explanation would be appreciated because I am basically lost at this point.  Thanks.

[ignace]

Did I go about putting the image in right?

 

Yes.

 

How would I go about retrieving these images from the database?

 

<img src="images.php?image_id=<id>" width="<width>" height="<height>">

 

images.php must echo out the contents of the BLOB field

 

[huntrguy102]

And what about the <id>, what do I do with that?

[huntrguy102]

ok this is the code for image.php

 

 

<?php

$conn = mysql_connect('localhost,'username','password') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('database',$conn) or trigger_error("SQL", E_USER_ERROR);

//table name is books
$sql = "SELECT * FROM books ORDER BY id LIMIT 2";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

//the field with the binary dat is called image
$image = $row['image']; 
header("Content-type: image/jpg"); // or whatever 
print $image; 
exit; 
?>

 

 

is this correct?  when I look at this php in the browser, it gives me a bunch of random symbols and letters and numbers.  Is that supposed to happen?

[huntrguy102]

any help would be appreciated

[fenway]

Then you're still printing another header somewhere.