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



vytlačiť článok  hľadať súvisiace články 



Chat ku článku

Vyhľadávanie na stránke
Reklama
Náhodný obrázok
náhodný obrázok
Kontakty

Martin Kasman, M Software
Smreková 3095/23
Email: martin@kasman.sk

Telefón: 0908 270 294