public static function getByLogin($login)
 {
     $user = null;
     try {
         $statement = DB::getInstance()->prepare('SELECT login, password, firstName, lastName, sex, email, birthDate AS birthDate, address, postalCode, city, phoneNumber FROM ' . self::getTableName() . ' where login=?');
         $statement->bindParam(1, $login);
         $statement->execute();
         if ($rs = $statement->fetch(PDO::FETCH_OBJ)) {
             $user = new User($rs->login, $rs->password, $rs->firstName, $rs->lastName, $rs->sex, $rs->email, $rs->birthDate, $rs->address, $rs->postalCode, $rs->city, $rs->phoneNumber);
         }
     } catch (PDOException $e) {
         die('Error!: ' . $e->getMessage() . '<br/>');
     }
     return $user;
 }
 /**
  * getByUser function. Get all Favorite of $user in db.
  *
  * @access public
  * @static
  * @param User object - $user
  * @return Favorite Objects Array
  */
 public static function getByUser($user)
 {
     $favorites = array();
     try {
         $statement = DB::getInstance()->prepare('SELECT * FROM ' . self::getTableName() . ' where login=?');
         $statement->bindValue(1, $user->getLogin());
         $statement->execute();
         while ($rs = $statement->fetch(PDO::FETCH_OBJ)) {
             $recipe = RecipeDAO::getById($rs->recipeId);
             $favorites[$rs->recipeId] = new Favorite($recipe, $user);
         }
     } catch (PDOException $e) {
         die('Error!: ' . $e->getMessage() . '<br/>');
     }
     return $favorites;
 }