Advertisement
Guest User

Untitled

a guest
Jan 1st, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. <?php
  2.  
  3. $host = '127.0.0.1';
  4. $db = 'test';
  5. $user = 'root';
  6. $pass = '';
  7. $charset = 'utf8';
  8.  
  9. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  10. $opt = [
  11. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  12. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  13. PDO::ATTR_EMULATE_PREPARES => false,
  14. ];
  15. $pdo = new PDO($dsn, $user, $pass, $opt);
  16.  
  17. $query = $pdo->query('SELECT * FROM test LIMIT 5');
  18. $rows = $query->fetchAll(PDO::FETCH_CLASS, 'ArrayObject');
  19. //print_r($rows);
  20.  
  21. foreach ($rows as $row) {
  22. //print_r($row);
  23. echo $row->id . "\n";
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement