PG_FETCH_OBJECT(3) PG_FETCH_OBJECT(3)
pg_fetch_object - Fetch a row as an object
SYNOPSIS
object pg_fetch_object (resource $result, [int $row], [int $result_type = PGSQL_ASSOC])
DESCRIPTION
object pg_fetch_object (resource $result, [int $row], [string $class_name], [array $params])
pg_fetch_object(3) returns an object with properties that correspond to the fetched row's field names. It can optionally instantiate an
object of a specific class, and pass parameters to that class's constructor.
Note
This function sets NULL fields to the PHP NULL value.
Speed-wise, the function is identical to pg_fetch_array(3), and almost as fast as pg_fetch_row(3) (the difference is insignificant).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $row
- Row number in result to fetch. Rows are numbered from 0 upwards. If omitted or NULL, the next row is fetched.
o $result_type
- Ignored and deprecated.
o $class_name
- The name of the class to instantiate, set the properties of and return. If not specified, a stdClass object is returned.
o $params
- An optional array of parameters to pass to the constructor for $class_name objects.
RETURN VALUES
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.
EXAMPLES
Example #1
pg_fetch_object(3) example
<?php
$database = "store";
$db_conn = pg_connect("host=localhost port=5432 dbname=$database");
if (!$db_conn) {
echo "Failed connecting to postgres database $database
";
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);
?>
SEE ALSO
pg_query(3), pg_fetch_array(3), pg_fetch_assoc(3), pg_fetch_row(3), pg_fetch_result(3).
PHP Documentation Group PG_FETCH_OBJECT(3)