Example of pg_num_rows, pg_fetch_result, pg_field_name
";
$result = pg_query($dbconn, "SELECT * FROM emp1 ORDER BY eid");
if (!$result) {
echo "An error occured.\n";
exit;
}
echo "---pg_fetch_result----
";
$rows = pg_num_rows($result);
$fields = pg_num_fields($result);
echo "No of rows/records :". $rows."
";
echo "No of fields :". $fields."
";
//
// pg_fetch_result(query-object, row, column-field
for($i=0; $i< $rows; $i++){
$val1 = pg_fetch_result($result, $i, 0);
$val2 = pg_fetch_result($result, $i,2 );
echo "row ". $i. " 2nd field : ".$val1." || "."3rd field : ".$val2."
";
}
echo "iterating with embedded loops
";
for($x=0; $x < 4; $x++)
{
for($y=0; $y < 5 ; $y++)
{
//echo " column :". $y ;
$r2 = pg_fetch_result($result, $x, $y);
$r3 = pg_field_name($result, $y);
echo $r3 ." = ".$r2.":";
}
echo "||
";
}
//
pg_free_result($result);
pg_close($dbconn);
echo"
db:: closed with pg_close() function
";
?>