Advertisement
teol

Exemple of a PDO MySQL query

Oct 26th, 2011
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.36 KB | None | 0 0
  1. <?php
  2.  
  3. $pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
  4. $pdo = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASS);
  5.        
  6. $requete = $pdo->prepare('SELECT COUNT(*) AS Nombre FROM banlist WHERE steamid = :steamid');
  7. $requete->bindValue(':steamid', $steam_ID);
  8. $requete->execute();
  9.        
  10. $donnees = $requete->fetch();
  11. $requete->closeCursor();
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement