From: Adam Lang <aalang@rutgersinsurance.com>
To: pgsql-php@hub.org
To: Chris <tomcat@weirdness.com>
Subject: Re: files, php & pgsql
Date: Wed, 18 Oct 2000 10:26:52 -0400
Message-ID: <009201c0390f$756c5320$330a0a0a@6014cwpza006> (raw)
References: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au>
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" <tomcat@weirdness.com>
To: <pgsql-php@hub.org>
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..
> <form enctype="multipart/form-data" name="fileinsert"
> action="file-insert.php" method="post">
> <input type="hidden" name="max_file_size" value="10000">
> <input type="file" size="35" name="userfile"><BR>
> <input type="submit" value="Upload It" name="uploadfile">
>
> I upload the files like this....
> <?php
> $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 <img src=\"blob2jpg.php?image=$image_oid\"
> border=0><br>";
> $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 |
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: aalang@rutgersinsurance.com, pgsql-php@hub.org, tomcat@weirdness.com
Subject: Re: files, php & pgsql
In-Reply-To: <009201c0390f$756c5320$330a0a0a@6014cwpza006>
References: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au> <009201c0390f$756c5320$330a0a0a@6014cwpza006>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox