pg_fetch_object

pg_fetch_object

Fetch a row as an object

 **pg_fetch_object** PgSql\Result $result  $row string $class array $constructor_args

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

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

result``rowRow number in result to fetch. Rows are numbered from 0 upwards. If omitted or null, the next row is fetched.

class The name of the class to instantiate, set the properties of and return. If not specified, a object is returned. stdClass

constructor_args An optional of parameters to pass to the constructor for objects. array``class

An with one attribute for each field name in the result. Database values are returned as null. object``NULL

false is returned if exceeds the number of rows in the set, there are no more rows, or on any other error. row

A is thrown when the is non-empty with the class not having constructor. ValueError``constructor_args

Voorbeeld: 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