Руководство по PHP
Пред. |  | След.

# pg_fetch_object

(PHP 3 >= 3.0.1, PHP 4, PHP 5)

pg_fetch_object -- Fetch a row as an object

## Описание

object pg_fetch_object ( resource result [, int row [, int result_type]] )
object pg_fetch_object ( resource result [, int row [, string class_name [, array params]]] )

pg_fetch_object() 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.

> Замечание: Эта функция устанавливает NULL-поля в значение `NULL` PHP.

Speed-wise, the function is identical to pg_fetch_array(), and almost as fast as pg_fetch_row() (the difference is insignificant).

> Замечание: row became optional in PHP 4.1.0.

> Замечание: result_type default changed from `PGSQL_BOTH` to `PGSQL_ASSOC` from PHP 4.3.0, since the numeric index was illegal.

> Замечание: class_name and params were added in PHP 5.0. The old form with result_type still exists for backwards compatibility.

## Список параметров

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, next row is fetched.

result_type

  Ignored and deprecated. Defaults to `PGSQL_ASSOC`.

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.

## Возвращаемые значения

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.

## Примеры

Пример 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);
?>`

## Смотрите также

pg_query()
pg_fetch_array()
pg_fetch_assoc()
pg_fetch_row()
pg_fetch_result()

Пред. | Начало | След.
pg_fetch_assoc | Уровень выше | pg_fetch_result