note 26257 added to function.pg-lo-open

From: 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

« previous php.notes (#38491) next »