note 26257 added to function.pg-lo-open
| From: | riccardo_ridenti at hotmail dot com | Date: | Thu, 24 Oct 2002 08:49:53 +0000 |
| Subject: | note 26257 added to function.pg-lo-open | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-38491@lists.php.net to get a copy of this message | ||
//INSERT FILE INTO DB
$fp = fopen($filename,"r");
$buffer = fread($fp,filesize($filename));
fclose($fp);
pg_query ($conn, "begin");
$oid = pg_lo_create ($conn);
//echo "$oid\n";
$rs = pg_exec($conn,"insert into table(object) values($oid);");//object field type must
be "oid"
$handle = pg_lo_open ($conn, $oid, "w");
//echo "$handle\n";
pg_lo_write ($handle, $buffer);
pg_lo_close ($handle);
pg_query ($conn, "commit"); //OR END
pg_close();
//GET BUFFER(file) FROM DB
$rs = pg_exec($conn,"select object from objects where id = xxxxxx;");
$row = pg_fetch_row($rs,0);
pg_query ($conn, "begin");
$loid = pg_lo_open($conn,$row[0], "r");
pg_lo_read_all ($loid);
pg_lo_close ($loid);
pg_query ($conn, "commit"); //OR END
pg_close();
--
http://www.php.net/manual/en/function.pg-lo-open.php
http://master.php.net/manage/user-notes.php?action=edit+26257
http://master.php.net/manage/user-notes.php?action=delete+26257
http://master.php.net/manage/user-notes.php?action=reject+26257