Advertisement
Guest User

Untitled

a guest
Aug 7th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.66 KB | None | 0 0
  1. <?php
  2. // tu se povežeš na bazo (host, port, ime baze, upo. ime, geslo)
  3. $conn = pg_connect("host=sheep port=5432 dbname=mary user=lamb password=foo");
  4. if (!$conn) {
  5.   // povezava ni uspela
  6.   echo "An error occured.\n";
  7.   exit;
  8. }
  9.  
  10. // vrni rezultat SQL stavka "SELECT id, author, email FROM authors"
  11. $result = pg_query($conn, "SELECT id, author, email FROM authors");
  12. if (!$result) {
  13.   // napaka pri izvedbi sql stavka
  14.   echo "An error occured.\n";
  15.   exit;
  16. }
  17.  
  18. // zanka ki gre skozi vse vrstice rezultata SQL stavka
  19. while ($row = pg_fetch_assoc($result)) {
  20.   // izpiši id, author, email
  21.   echo $row['id'];
  22.   echo $row['author'];
  23.   echo $row['email'];
  24. }
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement