include("headers.phtml");
MyHeader("PHP/FI Test Access to PostgreSQL Test#5");>
Whole data retrieval result:
$dbhost = $DB_HOST;
$dbport = $DB_PORT;
$dbname = $DB_NAME;
$tblname = $TBL_NAME;
$conn = pg_Connect($dbhost, $dbport, "", "", $dbname);
if (!$conn) {
echo "An error occured to Connect DB($dbname).\n";
exit;
}
$sqlcmd = "select * from $tblname";
$result = pg_Exec($conn, $sqlcmd);
if (!$result) {
echo "An error occured to Exec query($sqlcmd).\n";
exit;
}
$nf = pg_NumFields($result);
echo "";
echo "";
$j = 0;
while ($j < $nf);
$fldname[] = pg_FieldName($result, $j);
echo "| ";
echo $fldname[$j];
echo " | ";
$j++;
endwhile;
echo "
";
$nr = pg_NumRows($result);
$i = 0;
while ($i < $nr);
echo "
";
$j = 0;
while ($j < $nf);
echo "| ";
echo pg_Result($result, $i, $fldname[$j]);
echo " | ";
$j++;
endwhile;
echo "
";
$i++;
endwhile;
echo "
";
pg_FreeResult($result);
pg_Close($conn);
>
Query information:
echo "
";
echo " Command: $sqlcmd
";
echo " Result: $result
";
echo "
";
>
MyTrailer();>