1

I have a register form with email which should be unique. What I want to do is, if someone fills in an email which is alreday registered for another user, this someone to see a message, written by me, not something like 

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'admin@domain.com' for key 'UNIQ_1483A5E9E7927C74'

I tried this in the repository class:

public function getSameFriends ($email)
    {
        $q = $this->createQueryBuilder('f');

        $q->select('f')
          ->where('f.email = :email')      
          ->setParameter('email', $email);

        return $q->getQuery()->getSingleScalarResult();
    }

and then this in the controller:

$em = $this->getDoctrine()->getEntityManager();
        $count = $em->getRepository('EMMyFriendsBundle:Friend')
                                    ->getSameFriends($friend->getEmail());
        if($count != 0)
        {
            $this->get('session')->setFlash('notice', 'There already is a friend with this email!');
            return $this->redirect($this->generateUrl('home_display'));
        }

but I get an exception that

No result was found for query although at least one row was expected.
500 Internal Server Error - NoResultException

I don't need the result of the query, just to know if the results are 1 or 0. Do you have any idea how to make this?

Faery
  • 4,552
  • 10
  • 50
  • 92

1 Answers1

3

You can do:

return count($q->getQuery()->getResult());

BTW, have you looked at the 'uniqueEntity' validation constraint? It provides the functionality you need out of the box:

http://symfony.com/doc/current/reference/constraints/UniqueEntity.html

Carlos Granados
  • 11,273
  • 1
  • 38
  • 44
  • 1
    Alternate approach to just get a count: http://stackoverflow.com/questions/9214471/count-rows-in-doctrine-querybuilder/9215880#9215880 And keep in mind that there is always a slight chance that another user might submit the same email in between the time of your query and your controller's execution. So you should also surround your insert with a try/catch just in case. – Cerad Sep 13 '12 at 14:28