Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // tu se povežeš na bazo (host, port, ime baze, upo. ime, geslo)
- $conn = pg_connect("host=sheep port=5432 dbname=mary user=lamb password=foo");
- if (!$conn) {
- // povezava ni uspela
- echo "An error occured.\n";
- exit;
- }
- // vrni rezultat SQL stavka "SELECT id, author, email FROM authors"
- $result = pg_query($conn, "SELECT id, author, email FROM authors");
- if (!$result) {
- // napaka pri izvedbi sql stavka
- echo "An error occured.\n";
- exit;
- }
- // zanka ki gre skozi vse vrstice rezultata SQL stavka
- while ($row = pg_fetch_assoc($result)) {
- // izpiši id, author, email
- echo $row['id'];
- echo $row['author'];
- echo $row['email'];
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement