";
echo "Seznam osob se jmenem ".$jmeno.":
";
/* Prihlasi se do databaze : */
$conn = pg_connect("host=localhost dbname=databaze user=uzivatel password=heslo port=1599");
/* Priprava a spusteni dotazu : */
$query = "SELECT jmeno, prijmeni".
" FROM osoby".
" WHERE jmeno='".$jmeno."'".
" ORDER BY prijmeni, jmeno";
$res = pg_exec($conn, $query);
/* Zacatek HTML tabulky : */
echo "\n";
$nrows = pg_numrows($res); // Postgres vyzaduje citac radku
for ($row = 0; $row < $nrows; $row++) {
$data = pg_fetch_object($res, $row);
echo "".
"| ".$data->prijmeni." | ".
"".$data->jmeno." | ".
"
\n";
}
/* Konec HTML tabulky : */
echo "
\n";
/* Uvolneni prostredku zabranych dotazem : */
pg_freeResult($res);
/* Odhlaseni z databaze : */
pg_close($conn);
/* Konec HTML : */
echo "