you can not ouput html and binary data at the same time. you need to have image headers sent to the browser to show the image properly.

the best way to do this is to move the image processing code to a separate page and include it like this

echo '<img src="./path/to/image.php?id=$id">';

then the image page looks like this:

if($_GET['id']) {
$id = $_GET['id'];
// you may have to modify login information for your database server:


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

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

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



From: Chip Wiegand <[EMAIL PROTECTED]>
To: "PHP DB" <>
Subject: [PHP-DB] storing images in database
Date: Tue, 25 Jan 2005 09:11:07 -0800

I have stored a .jpg image in a database, then when I make a sql statement
to display that image on a web page all I get is the cryptic code in place
of the image. I am storing it in a row configured as a blob, mime type
image/jpeg and binary (using phpMyAdmin). What am I doing wrong?

PHP Database Mailing List (
To unsubscribe, visit:

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to