PHP完全中文操作手冊

pg_Fetch_Object

返回類資料。

語法: object pg_fetch_object(int result, int row);

返回值: 類

函數種類: 數據庫功能

內容說明

本函數用來將查詢結果 result 拆到類變量中。若 result 沒有資料，則返回 false 值。參數 result 為使用 pg_Exec() 所返回的代碼值。參數 row 為列數。

使用範例

<?php
$database = "verlag";
$db_conn = pg_connect("localhost", "5432", "", "", $database);
if (!$db_conn): ?>
<b>無法連上 <? echo $database ?> 數據庫</b><?php
exit;
endif;

$qu = pg_exec ($db_conn, "SELECT * FROM verlag ORDER BY autor");
$row = 0;

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;
while ($data = pg_fetch_object($qu, $row)):
echo "<hr><p>\n";
reset ($fields);
while (list (,$item) = each($fields)):
echo $item[1].": ".$data->$item[0]."\n";
endwhile;
$row++;
endwhile;
echo "<p><hr>"; ?>
</pre><?php
pg_freeResult($qu);
pg_close($db_conn);
?>