",
"Please verify that the application is running and ",
"listening on port 8888.
");
exit();
}
// Headings
print("\n");
print("| MyInt | \n");
print(" MyFloat | \n");
print(" Notes | \n");
print("
|---|
\n");
// execute query
$command = "SELECT myint, myfloat, notes FROM mytable";
$result = pg_exec($conn, $command);
if ($result == "") {
print("SQL Command failed!
");
print("Command: $command
\n");
exit();
}
for($row = 0; $row < pg_NumRows($result); $row++)
{
$myintstr = pg_result($result, $row, 0);
$myfloatstr = pg_result($result, $row, 1);
$mynotes = pg_result($result, $row, 2);
print("\n");
print("| $myintstr | \n");
print("$myfloatstr | \n");
print("$mynotes | \n");
print("
\n");
}
print("
\n");
// free the result and close the connection
pg_freeresult($result);
pg_close($conn);
?>