Guest User

Untitled

a guest
Nov 2nd, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. $host = 'localhost';
  2. $db = 'forum';
  3. $user = 'root';
  4. $pass = '';
  5. $charset = 'utf8';
  6.  
  7. $dsn = "mysql:host = $host; dbname = $db; charset=$charset";
  8. $opt = [
  9. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  10. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  11. PDO::ATTR_EMULATE_PREPARES =>false,
  12. ];
  13. $pdo = new PDO($dsn, $user, $pass, $opt);
  14. $stmt = $pdo->query('SELECT * FROM catalogs;');
  15. while ($row = $stmt->fetch()){
  16. echo $row['name'] . "n";
  17. }
Add Comment
Please, Sign In to add comment