Guest User

Untitled

a guest
Aug 1st, 2018
971
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. PDO in class not executing
  2. public function loginUser(PDO $db, $email, $password)
  3. {
  4. $this->_db = $db;
  5. $this->_email = $email;
  6. $this->_password = $password;
  7.  
  8. $user = $this->_checkCredentials();
  9. if ($user) {
  10. $this->_user = $user; // store it so it can be accessed later
  11. return $user['id'];
  12. }
  13.  
  14. return false;
  15. }
  16.  
  17. protected function _checkCredentials()
  18. {
  19. $stmt = $this->_db->prepare('SELECT * FROM member WHERE email = ? AND password = ?');
  20. $stmt->execute(array($this->_email, $this->_password));
  21. if ($stmt->rowCount() > 0) {
  22. $user = $stmt->fetch(PDO::FETCH_ASSOC);
  23. return $user;
  24. }
  25. return $stmt->debugDumpParams();
  26. }
  27.  
  28. $userService = new UserService();
  29. if ($user_id = $userService->loginUser($pdo, 'user@mail.com', 'userpass')) {
  30. echo 'Logged it as user id: '.$user_id;
  31. $userData = $userService->getUser();
  32. // do stuff
  33. } else {
  34. echo 'Invalid login';
  35. }
Add Comment
Please, Sign In to add comment