From: | surfer girl <gidget(at)getitgear(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | OID output problems |
Date: | 2000-05-02 21:00:15 |
Message-ID: | 20000502200015.40FB050BD@sitemail.everyone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 stuck on.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2000-05-02 21:07:56 | Re: OID output problems |
Previous Message | Ed Loehr | 2000-05-02 20:20:40 | Re: Need help with attributes... |