Re: Displaying Blobs by a newbie
| From: | Phil King | Date: | Sat, 13 Sep 2003 16:19:28 +0000 |
| Subject: | Re: Displaying Blobs by a newbie | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-162498@lists.php.net to get a copy of this message | ||
Hi Warren,
Thanks for your reply.
I imported the blobs into mysql database. They were in jpeg format.
Phil.
"Warren Vail" <Warren.Vail@bankofamerica.com> wrote in message
news:B5E4270285B4054C98246D301A0E91C90EAE87@ex2k.bankofamerica.com...
> You didn't say how the images were placed in the db but you did indicate
they were jpeg format.
>
> I'd try;
>
> fetching the db column in to a string variable;
>
> then;
>
> $im = imagecreatefromstring($imagestring);
> header ("Content-type: image/jpeg");
> imagejpeg($im);
> imagedestroy($im);
>
> good luck,
>
> Warren Vail
>
> -----Original Message-----
> From: Phil King [mailto:phil@phil-king.com]
> Sent: Friday, September 12, 2003 11:54 AM
> To: php-general@lists.php.net
> Subject: [PHP] Displaying Blobs by a newbie
>
>
> Hi All,
>
> I have some images in a mysql database. I wish to display all these images
> on a PHP Page.
>
> I have created a query to retrieve all the images from the database but
all
> that is displayed is characters.
> I have the Content-Type as image/jpeg in the header of the page to display
> the images.
>
> Can anyone advise me or point me in the right direction to rectify this.
>
> Thanks very much.
>
> Phil.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php