pg_fetch_result
(PHP 4 >= 4.2.0)
pg_fetch_result -- Returns values from a result resource
Description
mixed pg_fetch_result ( resource result, int row, mixed
field)
pg_fetch_result() returns values from a result resource
returned by pg_query(). row is integer. field is field name
(string) or field index (integer). The row and field specify
what cell in the table of results to return. Row numbering
starts from 0. Instead of naming the field, you may use
the field index as an unquoted number. Field indices start
from 0.
PostgreSQL has many built in types and only the basic ones
are directly supported here. All forms of integer types
are returned as integer values. All forms of float, and
real types are returned as float values. Boolean is returned
as "t" or "f". All other types, including
arrays are returned as strings formatted in the same default
PostgreSQL manner that you would see in the psql program.
pg_fetch_row
(PHP 3>= 3.0.1, PHP 4 )
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.
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 * FROM authors");
if (!$result) {
echo "An error occured.\n";
exit;
}
while ($row = pg_fetch_row($result, $i)) {
for ($j=0; $j < count($row); $j++) {
echo $row[$j] . " ";
}
echo "<br />\n";
}
?>
Note: From 4.1.0, row became optional. Calling pg_fetch_row()
will increment internal row counter by 1.
See also pg_query(), pg_fetch_array(), pg_fetch_object()
and pg_fetch_result().