Count Rows in Doctrine QueryBuilder

by

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.

More Related Contents:

  1. Using Relationships with Multiple Entity Managers
  2. symfony2: how to use group_concat in QueryBuilder
  3. The EntityManager is closed
  4. Symfony 2: Creating a service from a Repository
  5. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  6. How to convert this to Doctrine 2 QueryBuilder format?
  7. How to configure naming strategy in Doctrine 2
  8. Primary key of owning side as a join column
  9. Symfony2 : How to get form validation errors after binding the request to the form
  10. How to update a single library with Composer?
  11. Symfony2 file upload step by step
  12. How to check if an user is logged in Symfony2 inside a controller?
  13. Symfony2-Doctrine: ManyToMany relation is not saved to database
  14. How can I run symfony 2 run command from controller
  15. Symfony2: how to log user out manually in controller?
  16. How to set up entity (doctrine) for database view in Symfony 2
  17. Symfony 2 : multiple and dynamic database connection
  18. In Symfony2, why is it a bad idea to inject the service container, rather than individual services?
  19. How to inject the @request into a service?
  20. There is no extension able to load the configuration for “facebookbundle” symfony2
  21. FOS bundle – How to select users with a specific role?
  22. How to get config parameters in Symfony2 Twig Templates
  23. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  24. Build a form having a checkbox for each entity in a doctrine collection
  25. Get entityManager inside an Entity
  26. How to add custom link or button to SonataAdminBundle Dashboard in Symfony2
  27. How can I use DATE() in Doctrine 2 DQL?
  28. Adding Captcha to Symfony2 Login Page
  29. Symfony2 default locale in routing
  30. symfony2 chained selectors

Leave a Comment