Oracle like PostgreSQL employee Table
Uses pg_fetch_row($result)
"; $result = pg_query($dbconn, "SELECT * FROM emp ORDER BY ename"); if ($result) { echo "The query executed successfully.
\n"; // show name of the fields $i = pg_num_fields($result); for ($j = 0; $j < $i; $j++) { //echo "column $j\n"; $fieldname = pg_field_name($result, $j); echo $fieldname." ||"; //echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters\n"; //echo "storage length: " . pg_field_size($res, $j) . " bytes\n"; // echo "field type: " . pg_field_type($res, $j) . " \n\n"; } echo"
"; // for ($row = 0; $row < pg_num_rows($result); $row++) { $values = pg_fetch_row($result, $row); echo "\n"; } echo "

"; echo implode(' ', $values) . "

"; } else { echo "The query failed with the following error:
\n"; echo pg_last_error($db_handle); } pg_close($dbconn); ?>