Обсуждение: PHP & 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");
$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
So i see only the blob like a sequence of chars
Thanks,
Enrico
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
On Tue, 19 Sep 2000, Enrico Comini wrote: > echo "<img src=\"$img\" border=0>"; > > So i see only the blob like a sequence of chars You must output a "Content-Type" header as appropriate for the type of file you are sending out. Tom