php - 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();