pg_lo_read_all

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

    pg_lo_read_all — Lee un objeto de gran tamaño en su totalidad

    Descripción

    pg_lo_read_all(PgSql\Lob $lob): int

    pg_lo_read_all() lee un objeto de gran tamaño en su totalidad y lo envía directamente al cliente, después de los encabezados adecuados. Esta función está prevista para transmitir sonidos o imágenes.

    Para utilizar un objeto de gran tamaño (lo), es necesario hacerlo dentro de una transacción.

    Nota:

    Anteriormente, esta función se llamaba pg_loreadall().

    Parámetros

    lob

    An PgSql\Lob instance, returned by pg_lo_open().

    Valores devueltos

    Número de bytes leídos.

    Historial de cambios

    Versión Descripción
    8.1.0 The lob parameter expects an PgSql\Lob instance now; previously, a recurso was expected.

    Ejemplos

    Ejemplo #1 Ejemplo con pg_lo_read_all()

    <?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");
    ?>

    Ver también

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 2 notes

    up
    2
    robert dot bernier5 at sympatico dot ca
    20 years ago
    // remember, large objects must be obtained from within a transaction
    pg_query ($dbconn, "begin");

    // "assume" for this example that the large object resource number of the zipped file is "17899"

    $lo_oid = 17899;

    $handle_lo = pg_lo_open($dbconn,$lo_oid,"r") or die("<h1>Error.. can't get handle</h1>");

    //headers to send to the browser before beginning the binary download
    header('Accept-Ranges: bytes');
    header('Content-Length: 32029974'); //this is the size of the zipped file
    header('Keep-Alive: timeout=15, max=100');
    header('Content-type: Application/x-zip');
    header('Content-Disposition: attachment; filename="superjob.zip"');

    pg_lo_read_all($handle_lo) or
    die("<h1>Error, can't read large object.</h1>");

    // committing the data transaction
    pg_query ($dbconn, "commit");
    up
    0
    fabar2 at libero dot it
    13 years ago
    Pay attention that if you omit the "length" parameter it will read a 8192 bytes object regardless to its real dimensions. If you want to use this function think to save the object size somewhere (usually a field in its table) before reading the object. Alternatively use the pg_lo_readall function.
    ＋add a note
    To Top