Advertisement
Guest User

Untitled

a guest
Jan 12th, 2018
376
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "robin";
  7.  
  8. try {
  9. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  10. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  11. $stmt = $conn->prepare("SELECT Naam, Address, Woonplaats, Telefoonnummer FROM gebruikers");
  12. $stmt->execute();
  13.  
  14. // set the resulting array to associative
  15. $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
  16. foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
  17. echo $v;
  18. }
  19. }
  20. catch(PDOException $e) {
  21. echo "Error: " . $e->getMessage();
  22. }
  23. $conn = null;
  24. echo "</table>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement