pg_lo_create

(PHP 4 >= 4.2.0, PHP 5)

pg_lo_createCreate a large object

Description

int pg_lo_create ([ resource $connection [, mixed $object_id ]] )
int pg_lo_create ( mixed $object_id )

pg_lo_create() creates a large object and returns the OID of the large object. PostgreSQL access modes INV_READ, INV_WRITE, and INV_ARCHIVE are not supported, the object is created always with both read and write access. INV_ARCHIVE has been removed from PostgreSQL itself (version 6.3 and above).

To use the large object interface, it is necessary to enclose it within a transaction block.

Instead of using the large object interface (which has no access controls and is cumbersome to use), try PostgreSQL's bytea column type and pg_escape_bytea().

Note:

This function used to be called pg_locreate().

Parameters

connection

PostgreSQL database connection resource. When connection is not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().

object_id

If an object_id is given the function will try to create a large object with this id, else a free object id is assigned by the server. The parameter was added in PHP 5.3 and relies on functionality that first appeared in PostgreSQL 8.1.

Return Values

A large object OID or FALSE on error.

Changelog

Version Description
5.3.0

The optional object_id was added.

Examples

Example #1 pg_lo_create() example

<?php
   $database 
pg_connect("dbname=jacarta");
   
pg_query($database"begin");
   
$oid pg_lo_create($database);
   echo 
"$oid\n";
   
$handle pg_lo_open($database$oid"w");
   echo 
"$handle\n";
   
pg_lo_write($handle"large object data");
   
pg_lo_close($handle);
   
pg_query($database"commit");
?>

Коментарии

<?php
// --------- OPEN CONN ---

   
$conn pg_connect("host='127.0.0.1' dbname='test' user='usertest' password='passtest'");

// --------- OPEN FILE ---

   
$fp fopen('logo.gif'"r");
   
$buffer fread($fpfilesize('logo.gif'));
   
fclose($fp);

// --------- CREATE - INSERT OID ---

   
pg_exec($conn"begin");

   
$oid pg_locreate($conn);

   
$rs pg_exec($conn,"INSERT INTO test(tipo, images) VALUES('A1', $oid);");
   
$handle pg_loopen ($conn$oid"w");

   
pg_lowrite ($handle$buffer);
   
pg_loclose ($handle);

   
pg_exec($conn"commit");

// --------- OPEN - INSERT OID ---

   
$rs pg_exec($conn"SELECT images FROM test WHERE tipo = 'A1';");
   
$row pg_fetch_row($rs0);

   
pg_exec($conn"begin");
   
$loid pg_loopen($conn$row[0], "r");

   
header("Content-type: image/gif");

   
pg_loreadall($loid);
   
pg_loclose($loid);

   
pg_exec ($conn"commit");

// --------- UNLINK OID ---

   
pg_exec($conn"begin");

   
$loid $row[0];
   
pg_lounlink($conn$loid);

   
pg_exec ($conn"commit");

// --------- DELETE OID ---

   
pg_exec($conn"DELETE FROM test WHERE tipo = 'A1';");

// --------- CLOSE CONN ---

   
pg_close();
?>
2003-05-05 13:21:04
http://php5.kiev.ua/manual/ru/function.pg-lo-create.html

    Поддержать сайт на родительском проекте КГБ