RE: [PHP-DB] Re: [GENERAL] Postgres Large Object

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@rutgersinsurance.com] > 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@algobit.com> > To: "ML-PHP-DB" <php-db@lists.php.net> > 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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >