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

    说明

    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.

    注意: 此函数将 NULL 字段设置为 PHP null 值。

    参数

    result

    PgSql\Result 实例，由 pg_query()、pg_query_params() 或者 pg_execute()（等）返回。

    field

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

    返回值

    An array with all values in the result column.

    更新日志

    版本说明
    8.1.0 现在 result 参数接受 PgSql\Result 实例，之前接受 resource。

    示例

    示例 #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);

    ?>

    参见

    To Top