public function getByUsername($username)
 {
     //hämtar användaren!
     $connect = $this->createSqlConnection();
     $sqlQuery = "SELECT Username, Password FROM Register WHERE BINARY Username='******'";
     $connResult = $connect->query($sqlQuery);
     $row = $connResult->fetch_array();
     $this->closeSqlConnection();
     if (!isset($row)) {
         return null;
     }
     if ($row == NULL) {
         //om användarnamnet är null så returnerar det null!
         return null;
     }
     $user = new User($row["Username"]);
     $user->SetHashedPassword($row["Password"]);
     return $user;
 }