Count Rows in Doctrine QueryBuilder

symfony doctrine-orm
Acyra picture Acyra · Feb 9, 2012 · Viewed 248.1k times · Source

I'm using Doctrine's QueryBuilder to build a query, and I want to get the total count of results from the query. 

$repository = $em->getRepository('FooBundle:Foo');

$qb = $repository->createQueryBuilder('n')
        ->where('n.bar = :bar')
        ->setParameter('bar', $bar);

$query = $qb->getQuery();

//this doesn't work
$totalrows = $query->getResult()->count();

I just want to run a count on this query to get the total rows, but not return the actual results. (After this count query, I'm going to further modify the query with maxResults for pagination.)

Answer

Cerad picture Cerad · Feb 9, 2012

Something like:

$qb = $entityManager->createQueryBuilder();
$qb->select('count(account.id)');
$qb->from('ZaysoCoreBundle:Account','account');

$count = $qb->getQuery()->getSingleScalarResult();

Some folks feel that expressions are somehow better than just using straight DQL. One even went so far as to edit a four year old answer. I rolled his edit back. Go figure.

Related questions

How to sort findAll Doctrine's method?

I've been reading Doctrine's documentation, but I haven't been able to find a way to sort findAll() Results. I'm using symfony2 + doctrine, this is the statement that I'm using inside my Controller: $this->getDoctrine()->getRepository('MyBundle:MyTable')…

Read More
On delete cascade with doctrine2

I'm trying to make a simple example in order to learn how to delete a row from a parent table and automatically delete the matching rows in the child table using Doctrine2. Here are the two entities I'm using: Child.…

Read More
Doctrine query builder using inner join with conditions

I'd like to construct the following SQL using Doctrine's query builder: select c.* from customer c join phone p on p.customer_id = c.id and p.phone = :phone where c.username = :username First I tried $qb->select('c') …

Read More