Guest User

Untitled

a guest
Mar 4th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. <?php
  2. require_once 'DB.php';
  3.  
  4. class Auth {
  5. protected $pdo;
  6.  
  7. public function __construct() {
  8. $db = new DB();
  9. $db->baseConfig();
  10. $this->pdo = $db->pdo;
  11. }
  12.  
  13. public function login($login, $password) {
  14. $stmt = $this->pdo->prepare('SELECT * FROM users WHERE login = :login and password = :password');
  15. $stmt->execute(array('login' => $login, 'password' => md5($password)));
  16.  
  17. $user = $stmt->fetch();
  18.  
  19. if($user) {
  20.  
  21. $this->updateAuthTime($user['id']);
  22. }
  23.  
  24. return $user;
  25. }
  26.  
  27. public function updateAuthTime($user_id) {
  28.  
  29. $stmt = $this->pdo->prepare('UPDATE users SET lastVisit = :lastVisit WHERE id=:id');
  30. $result = $stmt->execute(array('id' => $user_id, 'lastVisit' => date('Y-m-d H:i:s')));
  31.  
  32. return $result;
  33. }
  34. }
Add Comment
Please, Sign In to add comment