Advertisement
Guest User

pdo

a guest
Feb 26th, 2019
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.54 KB | None | 0 0
  1. <?php
  2.  
  3. $dsn      = 'mysql:host=db;dbname=pdo';
  4. $user     = 'root';
  5. $password = 'secret';
  6.  
  7. $options = [
  8.     PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  9. ];
  10.  
  11. try {
  12.     $pdo = new PDO($dsn, $user, $password, $options);
  13. } catch (Exception $e) {
  14.     throw new PDOException($e->getMessage());
  15. }
  16.  
  17. // Query database with prepare & execute to avoid sql injection
  18. $stmt = $pdo->prepare('select * from users where email = :email');
  19. $stmt->execute([
  20.     'email' => 'marcin@yasiu.pl',
  21. ]);
  22.  
  23. $user = $stmt->fetch();
  24.  
  25. var_dump($user);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement