From: Dave Perkins <drp@shore.net>
To: Chris <tomcat@weirdness.com>
Cc: pgsql-php@hub.org
Subject: Re: files, php & pgsql
Date: Wed, 18 Oct 2000 07:38:52 -0500
Message-ID: <3.0.6.32.20001018073852.007e8d50@shell1.shore.net> (raw)
In-Reply-To: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au>
Ahhh . . . Guess this is likely not to be the problem, as it is clear that
it's the formatting of the message that breaks the line. Oops.
I'll let you know if I discover anything else.
Dave
At 08:45 PM 10/18/00 +1000, you wrote:
>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: drp@shore.net, tomcat@weirdness.com, pgsql-php@hub.org
Subject: Re: files, php & pgsql
In-Reply-To: <3.0.6.32.20001018073852.007e8d50@shell1.shore.net>
References: <4.3.2.7.2.20001018185338.00a9fcb0@mail.pharm.usyd.edu.au> <3.0.6.32.20001018073852.007e8d50@shell1.shore.net>
* 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