I get gibberish when I try to display fotos

yannis

Hi all.
I am trying to display images from MySql and the come up giberish. I have stored them as blobs in the db. I have tried anything and I can't get this to work.
Can somebody help?
I have been trying for 4 days now and no luck!!!!

bretticus

Yeah, unless you send a header saying which type of image it is, your browser will try and display it as HTML (php default.)

Set the header to the appropriate image:

header("Content-type: image/gif");
echo $image_from_mysql;

bretticus

Oh, and if you need images to show up in html, use two scripts. One to show the html and the other to be your src for images:

//<img src="images.php">

yannis

I get the following warning and after that I get the gibberish again.

Warning: Cannot modify header information - headers already sent by (output started at /home/content

my code is this:

if($id)
{
echo " ";
$result = mysql_query("SELECT * FROM myBlobs WHERE blobid=$id",$con_nit);

$row = mysql_fetch_array($result);
header("Content-type: image/gif");

echo " ";
printf("image: %s\n ", $row["blobData"]);
echo " ";
printf("type: %s\n ", $row["blobType"]);

}

The blobData field is supposed to have the image in it.

yelvington

Bretticus explained it correctly but you missed his point.

This is not a php problem. It is elementary HTML.

The way you put images into an HTML document is with the IMG tag, referencing a URL where the binary image data can be retrieved.

Your script places both HTML text and binary data in a single file.

Don't do that.

If you want to store images in a database, the image retrieval script should emit the proper mime-type header followed by the data. NOTHING else.