db = $db; } public function getUserById($userId) { } public function getUserByLogin($email, $password) { $sql = sprintf("SELECT user_id FROM users WHERE email = '%s' AND password = md5('%s') LIMIT 1", $email, $password); $result = $this->db->query($sql); if(!$result) { return false; } $userData = $result->fetch_assoc(); return $userData; } }