Lists: | pgsql-interfaces |
---|
From: | "Enrico Comini" <algobit(at)algobit(dot)com> |
---|---|
To: | "ML-Postgres-Interfaces" <Pgsql-Interfaces(at)Postgresql(dot)org> |
Subject: | PHP & Large Object |
Date: | 2000-09-19 16:22:14 |
Message-ID: | NCBBIOBMPJJBPJICNDLLEEFHDEAA.algobit@algobit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
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
From: | Vic <vic(at)dcc(dot)dp(dot)ua> |
---|---|
To: | algobit(at)algobit(dot)com |
Cc: | ML-Postgres-Interfaces <Pgsql-Interfaces(at)Postgresql(dot)org> |
Subject: | Re: PHP & Large Object |
Date: | 2000-09-20 00:19:16 |
Message-ID: | 39C80284.819CA13@dcc.dp.ua |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
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
From: | Tom Samplonius <tom(at)sdf(dot)com> |
---|---|
To: | Enrico Comini <algobit(at)algobit(dot)com> |
Cc: | ML-Postgres-Interfaces <Pgsql-Interfaces(at)postgresql(dot)org> |
Subject: | Re: PHP & Large Object |
Date: | 2000-09-20 04:20:59 |
Message-ID: | Pine.BSF.4.05.10009192120190.7784-100000@misery.sdf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
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