pg_fetch_object
(PHP 4, PHP 5, PHP 7)
pg_fetch_object — Fetch a row as an object
Descrierea
pg_fetch_object
( resource $result
, int $row
= ?
, int $result_type
= PGSQL_ASSOC
) : object
pg_fetch_object
( resource $result
, int $row
= ?
, string $class_name
= ?
, array $params
= ?
) : object
Notă:
Această funcție stabilește câmpurile NULL la valoarea PHP null
.
Speed-wise, the function is identical to
pg_fetch_array(), and almost as fast as
pg_fetch_row() (the difference is
insignificant).
Parametri
-
result
-
PostgreSQL query result resource, returned by pg_query(),
pg_query_params() or pg_execute()
(among others).
-
row
-
Row number in result to fetch. Rows are numbered from 0 upwards. If
omitted or null
, the next row is fetched.
-
result_type
-
Ignored and deprecated.
-
class_name
-
The name of the class to instantiate, set the properties of and return.
If not specified, a stdClass object is returned.
-
params
-
An optional array of parameters to pass to the constructor
for class_name
objects.
Valorile întoarse
An object with one attribute for each field
name in the result. Database NULL
values are returned as null
.
false
is returned if row
exceeds the number
of rows in the set, there are no more rows, or on any other error.
Exemple
Example #1 pg_fetch_object() example
<?php
$database = "store";
$db_conn = pg_connect("host=localhost port=5432 dbname=$database");
if (!$db_conn) {
echo "Failed connecting to postgres database $database\n";
exit;
}
$qu = pg_query($db_conn, "SELECT * FROM books ORDER BY author");
while ($data = pg_fetch_object($qu)) {
echo $data->author . " (";
echo $data->year . "): ";
echo $data->title . "<br />";
}
pg_free_result($qu);
pg_close($db_conn);
?>