src/PN/Bundle/UserBundle/Repository/UserRepository.php
/**
     * check verify email after 5 days
     * @param type $userId
     * @return bool
     */
check verify email after 5 days
@param type $userId
@return bool
check verify email after 5 days @param type $userId @return bool
public function isVerifyEmail($userId) {
        $connection = $this->getEntityManager()->getConnection();
        $sql = "SELECT id FROM `usr` WHERE id=:userId AND  confirmation_token IS NOT NULL and password_requested_at IS NULL AND DATEDIFF(NOW(), created) >=5";
        $statement = $connection->prepare($sql);
        $statement->bindValue("userId", $userId);
        $statement->execute();
        $result = $statement->fetchColumn();
        if (!$result) {
            return TRUE;
        }
        return FALSE;
    }
public function isVerifyEmail ( $ userId ) { $ connection = $ this -> getEntityManager ( ) -> getConnection ( ) ; $ sql = " SELECT id FROM `usr` WHERE id=:userId AND  confirmation_token IS NOT NULL and password_requested_at IS NULL AND DATEDIFF(NOW(), created) >=5 " ; $ statement = $ connection -> prepare ( $ sql ) ; $ statement -> bindValue ( " userId " , $ userId ) ; $ statement -> execute ( ) ; $ result = $ statement -> fetchColumn ( ) ; if ( ! $ result ) { return TRUE ; } return FALSE ; }
check verify email after 5 days
 @param type $userId
 @return bool
check verify email after 5 days @param type $userId @return bool