PDO::pgsqlLOBOpen

(PHP 5 >= 5.1.2, PHP 7, PECL pdo_pgsql >= 1.0.2)

PDO::pgsqlLOBOpen — Opens an existing large object stream

说明

public PDO::pgsqlLOBOpen ( string $oid [, string $mode = "rb" ] ) : resource

PDO::pgsqlLOBOpen() opens a stream to access the data referenced by oid. If mode is r, the stream is opened for reading, if mode is w, then the stream will be opened for writing. You can use all the usual filesystem functions, such as fread(), fwrite() and fgets() to manipulate the contents of the stream.

Note: This function, and all manipulations of the large object, must be called and carried out within a transaction.

参数

oid

A large object identifier.

mode

If mode is r, open the stream for reading. If mode is w, open the stream for writing.

返回值

Returns a stream resource on success 或者在失败时返回 FALSE.

范例

Example #1 A PDO::pgsqlLOBOpen() example

Following on from the PDO::pgsqlLOBCreate() example, this code snippet retrieves the large object from the database and outputs it to the browser.

<?php
$db = new PDO('pgsql:dbname=test host=localhost', $user, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->beginTransaction();
$stmt = $db->prepare("select oid from BLOBS where ident = ?");
$stmt->execute(array($some_id));
$stmt->bindColumn('oid', $oid, PDO::PARAM_STR);
$stmt->fetch(PDO::FETCH_BOUND);
$stream = $db->pgsqlLOBOpen($oid, 'r');
header("Content-type: application/octet-stream");
fpassthru($stream);
?>

参见

相关文章
php informix 函数 creates an slob object and opens itphp informix 函数 opens an slob objectphp postgresql 函数 truncates a large objectphp stream 函数 return a bucket object from the brigade for operating onphp oci lob returns current state of buffering for the large objectphp oci lob returns large object s contentsphp oci lob reads part of the large objectphp oci lob moves the internal pointer to the beginning of the large objectphp oci lob writes a temporary large objectphp postgresql pdo copy data from php array into tablephp postgresql pdo copy data from file into tablephp postgresql pdo copy data from database table into php arrayphp postgresql pdo creates a new large objectphp postgresql pdo opens an existing large object streamphp postgresql pdo deletes the large objectphp postgresql pdo connecting to postgresql databasesphp pdo 驱动 postgresql functions pdo pgsql php sqlite3 instantiates an sqlite3 object and opens an sqlite 3 databasephp sqlite3 opens a stream resource to read a blobphp streamwrapper destructs an existing stream wrapper
关注编程学问公众号