Thread: 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