Received: from bush.rutgersinsurance.com (IDENT:root@rutgersinsurance.com [38.138.71.194]) by hub.org (8.10.1/8.11.0) with ESMTP id e9IEOWW38235 for ; Wed, 18 Oct 2000 10:24:32 -0400 (EDT) (envelope-from aalang@rutgersinsurance.com) Received: from 6014cwpza006 ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id KAA07886; Wed, 18 Oct 2000 10:30:04 -0400 Message-ID: <009201c0390f$756c5320$330a0a0a@6014cwpza006> From: "Adam Lang" To: , "Chris" References: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au> Subject: Re: files, php & pgsql Date: Wed, 18 Oct 2000 10:26:52 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200010/30 X-Sequence-Number: 45 Do you get any type of error? Or does it just not do anything? Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Chris" To: Sent: Wednesday, October 18, 2000 6:45 AM Subject: files, php & pgsql > I've been thinking the same that the list is dead (or my mail was stuffed) > but now I see it's not the case :) > > I do have a problem (!!), and its trying to get files (of any type) to work > with pgsql & php. I'm using pgsql 7.0.2, php4. > > Anyone have any hints? > > Chris. > > Here's the form I use to upload the files.. >
action="file-insert.php" method="post"> > >
> > > I upload the files like this.... > $db=pg_connect("","","","","images"); > $fp=fopen("$userfile","r"); > pg_exec ($db,"begin"); > $loid = pg_locreate($db); > $lofp = pg_loopen($db, $loid, "w"); > while ($nbytes = fread ($fp, BUFSIZE)) > { > $tmp = pg_lowrite($lofp, $nbytes); > if ($tmp < $nbytes) echo "Error writing the file"; > } > $sql = "insert into images (picnum, image) values > (nextval('images_picnum_seq'), '$loid')"; > pg_exec($db,$sql); > pg_loclose($lofp); > pg_exec($db, "commit"); > fclose($fp); > echo "done"; > pg_close($db); > ?> > > I list the files like this.. > $db = pg_connect("","","","","images"); > $sql = "select * from images"; > $result = pg_exec($db, $sql); > if (!$result) {printf ("error"); } > $totalrows = pg_numrows($result); > $row=0; > do > { > $myrow = pg_fetch_object($result,$row); > $image_oid = $myrow->picnum; > echo "this is my image border=0>
"; > $row++; > }while ($row < $totalrows); > echo $pic; > ?> > > I (try to) display the files like this.... > $db=pg_connect("","","","","images"); > $sql="select * from images where picnum=$picnum"; > $result=pg_exec($db,$sql); > if (!$result) { printf ("error"); } > Header("Content-type: image/gif"); > $myrow = pg_fetch_object($result,0); > $image = $myrow->image; > pg_loreadall($image); > pg_close($db); > ?> > > and finally my database.. > images=# \d images > Table "images" > Attribute | Type | Modifier > -----------+---------+------------------------------- > picnum | integer | not null default...... > image | oid |