Guest User

Untitled

a guest
Dec 11th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. <?php
  2. $host = 'your host';
  3. $db = 'your dbname';
  4. $user = 'your user';
  5. $pass = 'your password';
  6. $charset = 'utf8mb4';
  7.  
  8. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  9. $options = [
  10. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  11. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  12. PDO::ATTR_EMULATE_PREPARES => false,
  13. ];
  14. try {
  15. $pdo = new PDO($dsn, $user, $pass, $options);
  16. } catch (\PDOException $e) {
  17. throw new \PDOException($e->getMessage(), (int)$e->getCode());
  18. }
  19.  
  20. $stmt = $pdo->query('SELECT name FROM users limit 1');
  21. while ($row = $stmt->fetch())
  22. {
  23. echo $row['name'] . "\n";
  24. }
Add Comment
Please, Sign In to add comment