Received: from baby.dcc.dp.ua (baby.dcc.dp.ua [195.24.157.226])
	by hub.org (8.10.1/8.10.1) with ESMTP id e8K0Scs85624
	for <Pgsql-Interfaces@Postgresql.org>;
	Tue, 19 Sep 2000 20:28:39 -0400 (EDT)
Received: from dcc.dp.ua (vic.dcc.intranet [192.168.83.246])
	by baby.dcc.dp.ua (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with ESMTP id
	CAA13343; Wed, 20 Sep 2000 02:53:20 +0300
Message-ID: <39C80284.819CA13@dcc.dp.ua>
Date: Wed, 20 Sep 2000 03:19:16 +0300
From: Vic <vic@dcc.dp.ua>
Organization: DCC
X-Mailer: Mozilla 4.06 [en] (Win95; I)
MIME-Version: 1.0
To: algobit@algobit.com
CC: ML-Postgres-Interfaces <Pgsql-Interfaces@Postgresql.org>
Subject: Re: PHP & Large Object
References: <NCBBIOBMPJJBPJICNDLLEEFHDEAA.algobit@algobit.com>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200009/75

 Hi  Enrico!
   I try  many times this  sample with  one result  -  image  was
fill  browser   as
  "sequence of  chars"  -  i see "dirty screen".  I  start  from
Postgres 6.5.3 and 1.3.6 with PHP 3.0.17,
but  in  other versions - systems i get a same result .

And   in febrary  this year  I  found in   one conf   sample   --- it
work  in  my  intranet.
  Try it.  I think   this trouble must be fixsed  and sample  added in
FAQ :-) )
>----------------------------------------------------------------------------------------------------------------------------------

FILE "image.php3"
<?
$db=pg_connect( "dbname=storage host=localhost user=pvic password=1");
$result=pg_exec( "select image from alldoc where n=$id");
$array=pg_fetch_array($result,0);
$oid=$array["image"];
header( "content-type: image/jpeg");
/* O   this  proc descr i  don't found in   any  doc  but i sure  -- it
pump to browser  type of  BLOB  */
if($oid) {
    pg_exec( "begin");
    $handle=pg_loopen($db,$oid, "r");
    if($handle){
        pg_loreadall($handle);
    }
    pg_loclose($handle);
    pg_exec($db, "commit");
    pg_exec($db, "end");
}
?>
>----------------------------------------------------------------------------------------------------------------------------------

FILE "ti.htm"
<HTML>
<BODY>
 <img src="image.php3?id=3">
</BODY>
</HTML>
>----------------------------------------------------------------------------------------------------------------------------------

Bye.


          Vic