displaying blob images from mysql

wayoutpost

I've been using php and mysql for all of, well, two days now. I've been using html and a bit of java for a while, but I'm finding that php and mysql are going to help me build a product list for a website I'm working on.

However, I've got one problem (well, so far). I have blob images stored in a database called dig513_auctions and a table called 'images'. The page I'm working on is just a testing page to see if I can get the images to display from the blob fields in the database. Here's the page: http://www.wayoutpost.com/images.php.

However, no matter what I try, I can't make the images appear from the database. Here's my php code:

<?php $con=mysql_connect("localhost", "<myusername>", "<mypassword>")or die("Connect Error: ".mysql_error());

$db="dig513_auctions";
mysql_select_db($db, $con);

$result = mysql_query("select * from images");

while ($row = mysql_fetch_object($result)) {
?>
Image id: <?php echo $row->imageid; ?> 
picture: 
<img src="getdata.php3?image=$image">

<?php
}
mysql_free_result($result);
mysql_close($con);
?>

~image~ is the field that contains the blobs.

Please excuse my "supa doopa newbie" ignorance. Help a brother out here.

Thanks!

wayoutpost

I have searched this site exhaustively for help on this topic. It seems like a lot of folks have had similar problems, but few have been able to actually make this work. I~ll keep looking! Baaaaa!

GilesGuthrie

OK, here's how you do it.

The following is a PHP file, that is called with this HTML:

<img src="showavatar.php?id="<?php echo mysql_result($avatardetail, 0, "ID"); ?>">

The idea is that the user uploads a graphic into the database, which is then used as an avatar in my forums page.

So, showavatar.php creates a file, which is passed straight to the browser as an Image.

<?php
require("tools.php");
if(isset($id))
{
	$filedata = mysql_query("SELECT * FROM forumAvatars WHERE ID = '".$id."' LIMIT 1");
	header("Content-type: \"".mysql_result($filedata, 0, "filetype")."\"");
// Work out whether we can show or download the attachment:
	$mimetype = explode("/", $row["filetype"]);
	if($mimetype[0] != "image")
	{
		header("Content-length: ".mysql_result($filedata, 0, "filesize"));
		header("Content-Disposition: attachment; filename=".mysql_result($filedata, 0, "filename"));
		header("Content-Description: PHP Generated Data");
	}
	echo mysql_result($filedata, 0, "Avatar");
}
?>

The core thing here is that if you are wishing to display the image, you just fire it at the browser. Otherwise, you pass the header information, and the browser will show a download screen.

Hope that helps!