Zkouska spojení z Postgresem
$con = pg_Connect("pyrrha", "5433", "", "", "pam");
if (!$con)
{
echo "Navazani spojeni selhalo!
";
echo pg_errorMessage($con);
exit;
}
echo "Spojeni bylo uspesne.
\n";
echo "Nyni jsi pripojen:
\n";
echo "k databazi: ", pg_DBname($con), "
\n";
echo "na stroji: ", pg_Host($con), "
\n";
echo "pres port: ", pg_Port($con), "
\n";
echo "
\n";
echo "K Postgresu na stroji ";
echo pg_Host($con);
echo "\nmaji pristup tito uzivatele zacinajici na pismeno p:
\n";
$result = pg_Exec($con, "select * from pg_user where usename like 'p%'");
if (!$result)
{
echo "Doslo k chybe.
\n";
echo pg_errorMessage($con);
exit;
}
$num = pg_NumRows($result);
$i = 0;
while ($i < $num)
{
echo pg_Result($result, $i, "usename"), "
\n";
$i++;
}
pg_FreeResult($result);
pg_Close($con);
>