Advertisement
Guest User

Ricercare utenti e mostrare i risultati

a guest
Apr 28th, 2015
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. #connessione al database
  2. try{
  3.     $pdo = new PDO('mysql:host=localhost;dbname=abc', 'abc', 'abc');
  4.     $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  5.     $pdo->exec('SET NAMES "utf8"');
  6. }
  7.    
  8. catch (PDOException $e) {
  9.     echo "Impossibile connettersi al database:". $e->getMessage();
  10.     exit();
  11. }
  12.  
  13. #recupero i valori
  14. $email = $_POST["email"];
  15. $password = $_POST["password"];
  16.  
  17. # ricerca dell'utente
  18. $sql = 'SELECT *
  19.     FROM registrazione
  20.     WHERE email = :email
  21.     AND password = :password';
  22. $s = $pdo->prepare($sql);
  23. $s->bindValue(':email', $email);
  24. $s->bindValue(':password', $password);
  25. $s->execute();
  26.  
  27. $result = $s->query($sql);
  28.  
  29. foreach($result as $row){
  30.     $utente[] = $row['nome'];
  31. }
  32. print_r($utente); #ma non stampa niente
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement