RE: [PHP-DB] Re: [GENERAL] Postgres Large Object From: Boaz Yahav (berber <email protected>)
Date: 09/19/00

Here is an article about how to show the image from the database.
it's for mysql but the idea is the same.

http://www.weberdev.com/index.php3?GoTo=ViewArticle.php3?ArticleID=3

Sincerely

     berber

Visit http://www.weberdev.com Today!!!
To see where PHP might take you tomorrow.

> -----Original Message-----
> From: Adam Lang [mailto:aalang <email protected>]
> Sent: Tuesday, September 19, 2000 7:49 PM
> To: ML-PHP-DB
> Subject: [PHP-DB] Re: [GENERAL] Postgres Large Object
>
>
> I have never done anything with that yet, but I THINK you
> need to send a
> header with the page to let the web client know that it is a
> picture to
> expect. Example: Header("Content-Type: image/gif");
>
> Look into it more at www.php.net
>
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> ----- Original Message -----
> From: "Enrico Comini" <algobit <email protected>>
> To: "ML-PHP-DB" <php-db <email protected>>
> Sent: Tuesday, September 19, 2000 11:09 AM
> Subject: [GENERAL] Postgres Large Object
>
>
> > Hi,
> > I' m a newbie with BLOBS.
> > I have pg-database with images in large object.
> > I read (with php) the blob but how to see this image ?
> >
> > .......
> > pg_exec ($conn, "begin");
> > $handle=pg_loopen($conn,68129,"r");
> > $img=pg_loreadall($handle);
> > pg_loclose($handle);
> > pg_exec ($conn, "end");
> >
> > echo "<img src=\"$img\" border=0>";
> >
> > So i see only the blob like a sequence of chars
> >
> > Thanks,
> > Enrico
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>