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. If you view the source it will provide a name of a temp file,
i.e.,/tmp/php08543baa
Am I missing something here? Or is the temp file not being written to properly or something?
Thanks in advance
_____________________________________________________________
Get It Gear --> http://www.getitgear.com