";
$sql ="SELECT * FROM emp1 WHERE eid=2 ";
$result = pg_query($dbconn, $sql);
if (!$result) {
echo "An error occured.\n";
exit;
}
echo "sql-query ".$sql. "
";
echo "---pg_fetch_array($result, 0, PGSQL_NUM);-----
";
$emp_array = pg_fetch_array($result, 0, PGSQL_NUM);
echo "eid::".$emp_array [0] . " || ";
echo "fname:: ".$emp_array [1] . " || ";
echo "lname ::".$emp_array [2] . " ||";
echo "address:: ".$emp_array [3] . "
";
echo "----------PGSQL_ASSOC-----------------
";
$arr = pg_fetch_array($result, NULL, PGSQL_ASSOC);
echo "emp fname :". $arr["fname"] ;
echo " : emp lname :".$arr["lname"]." ";
echo " : emp address :".$arr["address"]."
";
echo "pg_fetch_array — Fetch a row as an array
";
//
pg_close($dbconn);
echo" db:: closed with pg_close() function
";
?>
pg_fetch_array2.php
Hi there