Re: OID output problems

On Tue, 02 May 2000, surfer girl wrote:
> Hello,
>
> I am trying to write a program that will input and output images from a Postgres database using PHP.

I made a very simple display image routine as follows:

-------------------------------------------------------------------------------
<?php
/*
Takes arg: imageid=oid of image
*/

$conn = pg_pconnect("user=username dbname=databasename");

pg_exec($conn, "begin");
@ $fd = pg_loopen($conn, $imageid, "r");
if($fd) {
$hdr = pg_loread($fd, 4);
switch($hdr) {
case "\xFF\xD8\xFF\xE0":
Header( "Content-type: image/jpeg" );
break;
case "GIF8":
Header( "Content-type: image/gif" );
break;
case "\x89PNG":
Header( "Content-type: image/png" );
break;
}
echo $hdr;
pg_loreadall($fd);
pg_exec($conn, "end");
}
else {
echo "Query rejected.";
}

pg_close($conn);
?>
-------------------------------------------------------------------------------
--
Robert B. Easter
reaster(at)comptechnews(dot)com