PDO::pgsqlLOBOpen

Opens an existing large object stream ()
resource PDO::pgsqlLOBOpen ( string oid [, string mode] )

Example 1987. 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.

copy to clipboard

<?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', $lob, PDO::PARAM_LOB);
$stmt->fetch(PDO::FETCH_BOUND);
fpassthru($lob);
?>

PDO::pgsqlLOBOpen

Opens an existing large object stream () resource PDO::pgsqlLOBOpen ( string oid [, string mode] )

Example 1987. A PDO::pgsqlLOBOpen() example

Change Language

Opens an existing large object stream ()
resource PDO::pgsqlLOBOpen ( string oid [, string mode] )