PHP 7.0.6 Released

    pg_result_seek

    (PHP 4 >= 4.3.0, PHP 5, PHP 7)

    pg_result_seek — Set internal row offset in result resource

    Description

    bool pg_result_seek ( resource $result , int $offset )

    pg_result_seek() sets the internal row offset in a result resource.

    Parameters

    result

    PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).

    offset

    Row to move the internal offset to in the result resource. Rows are numbered starting from zero.

    Return Values

    Returns TRUE on success or FALSE on failure.

    Examples

    Example #1 pg_result_seek() example

    <?php

    // Connect to the database
    $conn = pg_pconnect("dbname=publisher");

    // Execute a query
    $result = pg_query($conn, "SELECT author, email FROM authors");

    // Seek to the 3rd row (assuming there are 3 rows)
    pg_result_seek($result, 2);

    // Fetch the 3rd row
    $row = pg_fetch_row($result);
     
    ?>

    See Also

    User Contributed Notes

    andrew-php dot net at andrew dot net dot au
    11 years ago
    Ah, this is a handy feature for resetting the record index, for example, if you're used pg_fetch_{row,array,assoc} to iterate over the result set, and you want to do it again later on, without reexecuting your query. Something like:

    <?php pg_result_seek($result, 0); ?>

    will allow you to iterate over the result set all over again...
    To Top