Re: SHOW PICTURE FROM DATABASE
| From: | nikos | Date: | Tue, 31 Dec 2002 08:18:50 +0000 |
| Subject: | Re: SHOW PICTURE FROM DATABASE | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24471@lists.php.net to get a copy of this message | ||
I've done it allredy!
It brings up a line of unknown characters
----- Original Message -----
From: John W. Holmes
To: 'Nikos Gatsis' ; 'PHP-mailist'
Sent: Tuesday, December 31, 2002 1:08 AM
Subject: RE: [PHP-DB] SHOW PICTURE FROM DATABASE
> 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;
> }
Call up showpict.php?pro_id=1 in Netscape and see if you get an error.
Just type it in and call it up by itself.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/