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
"; ?>