/* Vypíšeme tabulku knihy */
echo "Tabulka knihy:\n\n";
$database= pg_Connect ("", "", "", "", "vyuka");
$vystup = pg_Exec($database, "SELECT * FROM knihy ORDER BY autor");
$pocet = pg_NumRows($vystup);
printf("%-10s %-15s %6s\n", "Autor", "Název", "Cena");
echo "=================================\n";
$i = 0;
while ($i < $pocet ) {
$radek = pg_Fetch_Array($vystup, $i);
printf("%-10s %-15s %3.2f\n", $radek["autor"], $radek["nazev"], $radek["cena"]);
$i++;
}
/* Vypíšeme tabulku vypujcky */
echo "\nTabulka vypujcky:\n\n";
$vystup = pg_Exec($database, "SELECT * FROM vypujcky ORDER BY jmeno");
$pocet = pg_NumRows($vystup);
printf("%-10s %-4s\n", "Jmeno", "Index");
echo "=================================\n";
$i = 0;
while ($i < $pocet ) {
$radek = pg_Fetch_Array($vystup, $i);
printf("%-10s %d\n", $radek["jmeno"], $radek["index"]);
$i++;
}
?>