Guest User

Untitled

a guest
Jul 27th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.29 KB | None | 0 0
  1.   public function isLoggedIn() {
  2.     if(count($this->userInfo)) {
  3.       $id = !empty($this->userInfo['id']) ? intval($this->userInfo['id']) : false;
  4.       $username = !empty($this->userInfo['username']) ? $this->userInfo['username'] : false;
  5.       $password = !empty($this->userInfo['password']) ? $this->userInfo['password'] : false;
  6.       if($id !== false && $username !== false && $password !== false) {
  7.         try {
  8.           $stmt = $this->prepare("SELECT id, username, password FROM users WHERE id = :id AND username = :username AND password = :password LIMIT 1");
  9.           $stmt->bindParam(":id", $id, PDO::PARAM_INT);
  10.           $stmt->bindParam(":username", $username, PDO::PARAM_STR);
  11.           $stmt->bindParam(":password", $password, PDO::PARAM_STR);
  12.           $stmt->execute();
  13.           $stmt->bindColumn("id", $id, PDO::PARAM_INT);
  14.           $stmt->bindColumn("username", $username, PDO::PARAM_STR);
  15.           $stmt->bindColumn("password", $password, PDO::PARAM_STR);
  16.           $result = $stmt->fetch(PDO::FETCH_BOUND);
  17.           if($result) {
  18.             return $this->userInfo === compact("id", "username", "password");
  19.           }
  20.         } catch(PDOException $e) {
  21.           die("PDO Error: ({$e->getCode()}) {$e->getMessage()}");
  22.         }
  23.       }
  24.     }
  25.     return false;
  26.   }
Add Comment
Please, Sign In to add comment