Symfony2 & Doctrine - Get number of rows returned from datasource

Question

I have the following code in my Symfony2 Repository Class...

$query = $this->createQueryBuilder('foo')         ->where('foo.bar = :id')         ->setParameter('id', $myID)         ->getQuery(); 

How do I get the number of rows found by the database?

Thanks in advance

Answer 1

You need to execute DQL to do something you want.

$query = $this->createQueryBuilder()               ->from('foo', 'f')               ->where('foo.bar = :id')               ->setParameter('id', $myID)               ->getQuery();   $total = $query->select('COUNT(f)')                ->getQuery()                ->getSingleScalarResult();