Re: files, php & pgsql - Mailing list pgsql-php

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       |