Guest User

Untitled

a guest
Nov 23rd, 2018
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. <?php
  2.  
  3. // initialize base variables for PDO connection
  4. $host = 'localhost';
  5. $user = 'root';
  6. $password = '';
  7. $dbname = 'pdolab';
  8.  
  9. // initialize DSN
  10. $dsn = 'mysql:host=' . $host . ';dbname=' . $dbname;
  11.  
  12. // initialize PDO connection
  13. $pdo = new PDO($dsn, $user, $password);
  14.  
  15. // PDO query
  16.  
  17. $statement = $pdo->query('SELECT * FROM posts');
  18.  
  19. while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
  20. echo $row['title'] . '<br>';
  21. }
Add Comment
Please, Sign In to add comment