Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4. <title>Test</title>
  5. </head>
  6.  
  7. <body bgcolor="white">
  8.  
  9. <?php
  10. $connection_string="dbname=postgres port=5432 user=postgres password=admin"
  11. $link = pg_connect(string $connection_string[,int PGSQL_CONNECT_FORCE_NEW]);
  12.  
  13. //$link = pg_connect("dbname=postgres user=postgres password=admin"[,int ]);
  14. $result = pg_exec($link, "select * from customers");
  15. $numrows = pg_numrows($result);
  16. echo "<p>link = $link<br>
  17. result = $result<br>
  18. numrows = $numrows</p>
  19. ";
  20. ?>
  21.  
  22. <table border="1">
  23. <tr>
  24. <th>Last name</th>
  25. <th>First name</th>
  26. <th>ID</th>
  27. </tr>
  28. <?php
  29.  
  30. for($ri = 0; $ri < $numrows; $ri++) {
  31. echo "<tr>n";
  32. $row = pg_fetch_array($result, $ri);
  33. echo " <td>", $row["fname"], "</td>
  34. <td>", $row["lname"], "</td>
  35. <td>", $row["id"], "</td>
  36. </tr>
  37. ";
  38. }
  39. pg_close($link);
  40. ?>
  41. </table>
  42.  
  43. $db = new PDO('pgsql:dbname=mydb;host=localhost;user=myuser;password=mypass');
  44. $res = $db->query("SELECT * FROM sometable")->fetchAll(PDO::FETCH_ASSOC);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement