(3.0.1 - 3.0.18 only, PHP 4 >= 4.0.0)
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.
See also: pg_exec(), pg_fetch_array(), pg_fetch_object() and
pg_result().
|
Example 1. Postgres fetch row
<?php
$conn = pg_pconnect ("dbname=publisher");
if (!$conn) {
echo "An error occured.\n";
exit;
}
$result = pg_Exec ($conn, "SELECT * FROM authors");
if (!$result) {
echo "An error occured.\n";
exit;
}
$num = pg_numrows($result);
for ($i=0; $i < $num; $i++) {
$r = pg_fetch_row($result, $i);
for ($j=0; $j < count($r); $j++) {
echo "$r[$j]∓nbsp;";
}
echo "<BR>";
}
?>
|
|
|
