Retrieving binary image data

Anon

Evening, afternoon, morning depending on where u are. I am very very new to this php, mysql dance and want to simply display images (longblob) and text out of my database but for some reason the images arent showing up. This is the code... (dont laugh)

<?php

$db = mysql_connect("localhost","root");
mysql_select_db("antiques",$db) or die(mysql_errno() . ": " . mysql_error() . " ");

$sql = "SELECT * FROM general ";
$sql .= "ORDER BY filename ASC";
$result = mysql_query($sql, $db);
$rows = mysql_num_rows($result);

echo "<table border=1>\n";
echo " <tr>\n";
echo " <td>Image</td>\n";
echo " <td>Name</td>\n";
echo " <td>Description</td>\n";
echo " <td>Price</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";

for ($i = 0; $i < $rows; $i++) {
$data = mysql_fetch_object($result);
echo " <td><IMG SRC=getdata.php?id=$i></td>\n";
echo " <td>$data->name</td>\n";
echo " <td>$data->description</td>\n";
echo " <td>$data->price</td>\n";
echo " </tr>\n";

}
mysql_free_result($result);
mysql_close($db);
?>

...and this the getdata.php (which came from this site). If anyone doesnt mind helping me out here it would be much appreciated..

<?php

if(isset($id)) {

@MYSQL_CONNECT("localhost","root");

@mysql_select_db("antiques");

$query = "select image,filetype from image where id=$id";
$result = @MYSQL_QUERY($query);

$data = @MYSQL_RESULT($result,0,"image");
$type = @MYSQL_RESULT($result,0,"filetype");

Header( "Content-type: $type");
echo $data;

};
?>

piosthyn

Hi,

Lets see, I have done a similar thing before, and this has worked for me.

</b>
In the file image.php I had this code

<?php
 $cn = mysql_connect($dbHost,$dbUser,$dbPassword);

$rs = mysql_query("SELECT IMAGEDATA,IMAGEID FROM IMAGES WHERE IMAGEID = ".$imageId;

$dta = mysql_fetch_row($rs);

header("Content-type: image/gif");
echo $dta[0];
?>
<b>

where I wanted the image I called it like this

</b>
<?php
......
echo "<img src='image.php?ImageId='".$databaseresult[1]."'>";
..........
<B>

That seemed to do the trick for me.
But if you have any hassles I am sure I can try to help you

piosthyn

PS. The header works for ANY image type.

Anon

Hey thanks for your reply.... i dont think that the problem is the image.php or the getdata.php in my case (example in orig message) it just doesnt seem to be passing the variable into that script. The images appear fine if i am just calling them from a normal page using the <img src=getdata.php?id=#> method, but as soon as i try and slap it into another script that is pulling text info out of the database , it doesnt work. funny thing is that if you look at the properties of the missing images on the resultant page they appear to have recieved their value i.e <img src=getdata.php?id=3> (if that makes any sense). When they are uploaded they are assigned an $id so that is what i have been calling. I hope my description makes sense, thanks a lot for your help...starting to pull hair out

greg252

I have to say that I disagree with storing images in a database. Even the mySQL manual states that you shouldn't do this- it makes for ultra-large databases. Instead, store the name of the image file in the database with whatever other fields you need for selection/ normalization purposes. Save the images in a seperate directory (even out of the server path, if necessary).