include("headers.phtml");
MyHeader("PHP/FI Test Access to PostgreSQL Test#4");>
Result of retrieval from: echo "$DB_NAME.$TBL_NAME";>
$dbhost = $DB_HOST;
$dbport = $DB_PORT;
$dbname = $DB_NAME;
$tblname = $TBL_NAME;
$sqlcmd = "select ";
$j = 0;
$nf = 0;
$cols = "";
$conds = "";
while ($j < $NCOLS);
if ($COL[$j] == "on" ) {
if ($cols != "" ){
$cols += ", ";
}
$cols += "$COL_NAME[$j]";
$nf++;
}
if ($COND[$j] != "" ) {
if ($conds == "" );
$conds = " WHERE ";
else;
$conds += " AND ";
endif;
$conds += "$COL_NAME[$j] $COND[$j]";
}
$j++;
endwhile;
if ($nf == 0) {
echo "";
exit;
}
$sqlcmd += "$cols FROM $tblname";
$sqlcmd += StripSlashes($conds);
$conn = pg_Connect($dbhost, $dbport, "", "", $dbname);
if (!$conn) {
echo "An error occured to Connect DB($dbname).\n";
exit;
}
$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 " Field(s):$cols
";
echo " Condition(s):$conds
";
echo "
";
>
MyTrailer();>