pg_fetch_row

(PHP 3>= 3.0.1, PHP 4 , PHP 5)

pg_fetch_row -- Get a row as an enumerated array

Description

array pg_fetch_row ( resource result [, int row] )

pg_fetch_row() fetches one row of data from the result associated with the specified result resource. The row (record) is returned as an array. Each result column is stored in an array offset, starting at offset 0.

It returns an array that corresponds to the fetched row, or FALSE if there are no more rows.

Poznámka: Tato funkce nastavuje pole s hodnotou NULL na hodnotu PHP NULL.

Příklad 1. pg_fetch_row() example

<?php

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

$result = pg_query($conn, "SELECT author, email FROM authors");
if (!
$result) {
    echo
"An error occured.\n";
    exit;
}

while (
$row = pg_fetch_row($result)) {
    echo
"Author: $row[0]  E-mail: $row[1]";
    echo
"<br />\n";
}

?>

Poznámka: From 4.1.0, row became optional. Calling pg_fetch_row() will increment the internal row counter by one.

See also pg_query(), pg_fetch_array(), pg_fetch_object() and pg_fetch_result().