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.
Note: This function sets NULL fields to
PHP NULL value.
Note:
From 4.1.0, row became optional.
Calling pg_fetch_row() will increment
the internal row counter by one.
Examples
Example 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";
}
?>
|
|