dbl

dbl.php

    public function getIdByEmail($sEmail)
    {
        $aResult = $this->getEntityManager()
            ->createQuery("SELECT user.id FROM EducationBaseBundle:User user WHERE user.mail = :mail")
            ->setParameter('mail', $sEmail)
            ->getOneOrNullResult();
        if (isset($aResult['id'])) {
            return $aResult['id'];
        }
        return 0;
    }