pg_fetch_all_columns

    (PHP 5 >= 5.1.0, PHP 7, PHP 8)

    pg_fetch_all_columns — Fetches all rows in a particular result column as an array

    Descripción

    pg_fetch_all_columns(PgSql\Result$result, int$field = 0): array

    pg_fetch_all_columns() returns an array that contains all rows (records) in a particular column of the PgSql\Result instance.

    Nota: Esta función define campos NULOS al valor null de PHP.

    Parámetros

    result

    An PgSql\Result instance, returned by pg_query(), pg_query_params() or pg_execute()(among others).

    field

    Column number. Defaults to the first column if not specified.

    Valores devueltos

    An array with all values in the result column.

    Historial de cambios

    VersiónDescripción
    8.1.0 The result parameter expects an PgSql\Result instance now; previously, a recurso was expected.

    Ejemplos

    Ejemplo #1 pg_fetch_all_columns() example

    <?php
    $conn     = pg_pconnect("dbname=publisher");
    if (!    $conn) {
    echo     "An error occurred.\n";
    exit;
    }

    $result = pg_query($conn, "SELECT title, name, address FROM authors");
    if (!    $result) {
    echo     "An error occurred.\n";
    exit;
    }

    // Get an array of all author names
    $arr = pg_fetch_all_columns($result, 1);

    var_dump($arr);

    ?>

    Ver también

    • pg_fetch_all() - Obtiene todas las filas de un resultado como un array
    To Top