From: Vic <vic@dcc.dp.ua>
To: algobit@algobit.com
Cc: ML-Postgres-Interfaces <Pgsql-Interfaces@Postgresql.org>
Subject: Re: PHP & Large Object
Date: Wed, 20 Sep 2000 03:19:16 +0300
Message-ID: <39C80284.819CA13@dcc.dp.ua> (raw)
References: <NCBBIOBMPJJBPJICNDLLEEFHDEAA.algobit@algobit.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: vic@dcc.dp.ua, algobit@algobit.com
Subject: Re: PHP & Large Object
In-Reply-To: <39C80284.819CA13@dcc.dp.ua>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox