Advertisement
Guest User

Untitled

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