Home/ Manual/ pgsql / functions/ pg_lo_read_all

pg_lo_read_all

PHP function Edit on GitHub ✎

(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

Reads an entire large object and send straight to browser

Description

pg_lo_read_all(PgSql\Lob $lob): int

pg_lo_read_all() reads a large object and passes it straight through to the browser after sending all pending headers. Mainly intended for sending binary data like images or sound.

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

Note

This function used to be called pg_loreadall().

Parameters

lob: Lob

Return Values

Number of bytes read.

Changelog

Version	Description

Examples

pg_lo_read_all() example

php

<?php
   header('Content-type: image/jpeg');
   $image_oid = 189762345;
   $database = pg_connect("dbname=jacarta");
   pg_query($database, "begin");
   $handle = pg_lo_open($database, $image_oid, "r");
   pg_lo_read_all($handle);
   pg_query($database, "commit");
?>