Advertisement
Guest User

Untitled

a guest
Mar 10th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. function userExists($pdow, $login)
  2. {
  3. $userQuery = "SELECT * FROM login u WHERE login=:user;";
  4. $stmt = $pdow->prepare($userQuery);
  5. $stmt->execute(array(':user' => $login));
  6. return !!$stmt->fetch(PDO::FETCH_ASSOC);
  7. }
  8.  
  9. $login = 'user';
  10. $exists = userExists($pdow, $login);
  11. if('$login')
  12. $user= var_dump((bool) 'Exists');
  13. {
  14. echo "Login exsists!";
  15. }
  16.  
  17. if($login)
  18. // this line doesnt make any sense!
  19. // $user= var_dump((bool) 'Exists');
  20. // so this is not a valid if clause
  21. {
  22. echo "Login exsists!";
  23. }`
  24.  
  25. $servername = '';
  26. $dbname = '';
  27. $username = '';
  28. $password = '';
  29. $dbh = new PDO("mysql:host={$servername};dbname={$dbname}", $username, $password);
  30.  
  31.  
  32. function user_exists($dbh, $login) {
  33. $Q = $dbh->prepare("SELECT * FROM login WHERE login = :Login");
  34. $Q->bindParam(':login', $Login);
  35. $Q->execute();
  36.  
  37. if ($Q->rowCount() != 0) {
  38. //User exist:
  39. return $Q->fetch(PDO::FETCH_ASSOC);
  40. } else {
  41. //User doesn't exist.
  42. return false;
  43. }
  44. }
  45.  
  46. //Lets try:
  47. $check = user_exists($dbh, 'email@example.com');
  48. if ($check) {
  49. echo 'User: ' . $check['login'] . ' was found int he database.';
  50. } else {
  51. echo 'The user was NOT found.';
  52. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement