/* 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++; } ?>