pg_Fetch_Object

Syntax

object pg_Fetch_Object(int result, int row);

Popis

Príkaz jazyka PHP
pg_Fetch_Object - fetch row as object

Returns: An object with properties that correspond to the fetched row, or false if there are no more rows.

pg_fetch_object is similar to pg_fetch_array, with one difference - an object is returned, instead of an array. Indirectly, that means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).

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

Príklad

<?php
$database = "verlag";
$db_conn = pg_connect ("localhost", "5432", "", "", $database);
if (!$db_conn): ?>
<H1>Failed connecting to postgres database <? echo $database ?></H1> <?
exit;
endif;

$qu = pg_exec ($db_conn, "SELECT * FROM verlag ORDER BY autor");
$row = 0; // postgres needs a row counter other dbs might not

while ($data = pg_fetch_object ($qu, $row)):
  echo $data->autor." (";
  echo $data->jahr ."): ";
  echo $data->titel."<BR>";
  $row++;
endwhile; ?>
<PRE><?php
$fields[] = Array ("autor", "Author");
$fields[] = Array ("jahr", " Year");
$fields[] = Array ("titel", " Title");

$row= 0; // postgres needs a row counter other dbs might not
while ($data = pg_fetch_object ($qu, $row)):
  echo "-- -- --\n";
  reset ($fields);
  while (list (,$item) = each ($fields)):
    echo $item[1].": ".$data->$item[0]."\n";
  endwhile;
  $row++;
endwhile;
echo "-- -- --\n"; ?>
</PRE> <?php
pg_freeResult ($qu);
pg_close ($db_conn);
?>


Pozri aj

pg_Fetch_Array, pg_Fetch_Row