SHOW PICTURE FROM DATABASE
| From: | Nikos Gatsis | Date: | Mon, 30 Dec 2002 21:55:57 +0000 |
| Subject: | SHOW PICTURE FROM DATABASE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24468@lists.php.net to get a copy of this message | ||
Hello there and Marry Christmas!
I have a php script that call binary data of pictures stored in database.
The script works fine in IE but not in Netscape (ver 4.7, & 6.01).
Any ideas?
---------------------------------
the html tag is like: <img src="showpict.php?pro_id=1">
where showpict.php:
$query="SELECT pict FROM pict WHERE pro_id= '$pro_id";
$result=mysql_db_query($database, $query, $conn) or Die (mysql_error());
list($photo)=mysql_fetch_row($result);
$type = $photo_type;
if (!empty($photo)) {
header("Content-Type: {$type}");
echo $photo;
}
THANX
Nikos