Re: [GENERAL] Postgres Large Object
| From: | Adam Lang | Date: | Tue, 19 Sep 2000 17:49:05 +0000 |
| Subject: | Re: [GENERAL] Postgres Large Object | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2975@lists.php.net to get a copy of this message | ||
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
>