On Tue, 2 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.
>
> The inputting seems to be going fine - well, it seems to be fine, since I can't test it because it's the output I'm
stuckon.
>
> What I've got so far is:
>
> <?PHP
> Header("Content-type: image/gif");
> (DATABASE CONNECT STUFF HERE)
> pg_exec ($conn, "BEGIN");
> $result = pg_Exec($conn, "SELECT file FROM file WHERE key_fileid = '7'");
> $oid = pg_Result($result, 0, "file");
> $handle = pg_loopen($conn, $oid, "r");
> pg_loreadall($handle);
> pg_exec ($conn, "COMMIT");
> ?>
>
> What this does is print up a broken image in the browser.
I known this proble. You are probably right. A problem (IMHO) is in PHP.
Try use insdead pg_readall() this code with pg_loread():
$data = pg_loread($handle, 5000000 /* or a exactly size */);
echo $data;
Karel
