displaying image from blob (binary store)

[SeenGee]

I have an image upload system (inherited from previous webmaster) which stores images in mysql as a blob, simple question, how do i display them as images?

[SeenGee]

please note that there is no filename or filetype stored that i can see, just the blob.

[drakahn]

...
oohkay i don't use this but the way i understand it is

a) make a php file to do nothing but call the blob, we'll name it image.php

b) put <img src=image.php> where you want the image to be

---

image.php wouldbe

<?
Header ("Content-type: image/png");
$image = mysql_fetch_array(mysql_query("select * from images where id=$id"));
print"$image[blob]";
?>
(many ways to make it better....)

[SeenGee]

thanks but i'd like to work out what they are doing exactly.

on another similar page the image is called like this:

<img src="../prospectusimage.php?pid=<?php echo $pid ?>">

My image is added like this: (snippet of code taken from original code):

if (is_uploaded_file($_FILES['nw_image']['tmp_name'])){
	$fn = $_FILES['nw_image']['tmp_name'];
	$fp=fopen($fn,"rb");
	$fs=filesize($fn);
	$image=fread($fp,$fs);
	fclose($fp);
}

$sql = "INSERT INTO `newsbak` SET".
	" nw_college = ".$college['college_id'].
	", nw_title = '".addslashes(trim($_POST['nw_title']))."'".
	", nw_text = '".addslashes(trim($_POST['nw_text']))."'".
	", nw_date = now()".
	", nw_image = '".addslashes($image)."'";

i think the mod rewrite has something to do with how this works, this is the line i think matters:

RewriteRule ^{newsimage_([.]+).jpg} newsimage.php?nwid=$1

[Weedpacket]

Thing is, they're not even using that rewrite rule. Even taking into account the difference between newimage and prospectusimage,

newsimage.php?nwid=42

is what the URL is supposed to contain after the URL is applied. In the page it should be written as

newsimage_42.jpg

so that the rewrite rule would convert it.