Advertisement
Guest User

Untitled

a guest
Dec 12th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. $email= "example@something";
  2.  
  3. $host = 'localhost';
  4.  
  5. $dbname = 'users';
  6.  
  7. $username = 'root';
  8.  
  9. $password = '';
  10.  
  11. $conn = new PDO("mysql:host = $servername;dbname =
  12.  
  13. $dbname",$username,$password);
  14.  
  15. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  16.  
  17. $query = $conn->prepare("SELECT email FROM users.registered_users WHERE
  18.  
  19. email='$email'");
  20.  
  21. $query->execute(array($email));
  22.  
  23. $row = $query->fetch(PDO::FETCH_BOTH);
  24.  
  25. if($query->rowCount() > 0) {
  26.  
  27. echo "email found";
  28.  
  29. } else {
  30.  
  31. echo "email not found";
  32.  
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement