Advertisement
Guest User

Requête BDD avec PDO (en PHP)

a guest
Aug 22nd, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.49 KB | None | 0 0
  1. <?php
  2. /* Connexion avec PDO
  3. $dsn = 'mysql:dbname=mabase;host=localhost';
  4. $user = 'user';
  5. $password = 'password';
  6.  
  7. try
  8. {
  9.     $dbh = new PDO($dsn, $user, $password);
  10. }
  11. catch(PDOException $e)
  12. {
  13.     echo 'ERREUR Connexion : ' . $e->getMessage();
  14. }
  15.  
  16. /* Requête sécurisée */
  17. $sql = 'SELECT * FROM table_news WHERE author = :author';
  18. $fields = ['author' => 'Tom'];
  19.  
  20. $req= $dbh->prepare($sql, [PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY]);
  21.  
  22. $req->execute($fields);
  23. $datas = $sth->fetchAll();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement