Query on a many-to-many relationship using Doctrine with Symfony2

by

You can write a join DQL query as below

$em = $this->getContainer()->get('doctrine')->getManager();
$repository = $em->getRepository('YourNamespaceYourBundle:User');
$query = $repository->createQueryBuilder('u')
    ->innerJoin('u.groups', 'g')
    ->where('g.id = :group_id')
    ->setParameter('group_id', 5)
    ->getQuery()->getResult();

Your mapping for groups property in User entity will handle join part itself you don’t have to mention the junction table in your DQL query

More Related Contents:

  1. How to set up entity (doctrine) for database view in Symfony 2
  2. How can I use DATE() in Doctrine 2 DQL?
  3. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  4. On delete cascade with doctrine2
  5. Doctrine 2 and Many-to-many link table with an extra field
  6. Doctrine Query Language get Max/Latest Row Per Group
  7. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  8. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  9. How to setup table prefix in symfony2
  10. PDOException “could not find driver” in php
  11. getting the value of an extra pivot table column laravel
  12. Symfony 2.0 getting service inside entity
  13. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  14. How to force Doctrine to update array type fields?
  15. Join subquery with doctrine 2 DBAL
  16. Select mySQL based only on month and year
  17. Mysql InnoDB engine in Laravel
  18. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  19. PHP: mysql v mysqli v pdo [closed]
  20. How do I ensure I caught all errors from MySQLi::multi_query?
  21. PHP MySQL set Connection Timeout
  22. Sort by date (newest)
  23. How can I insert large files in MySQL db using PHP?
  24. The ultimate emoji encoding scheme
  25. mysql count occurrences of special character in a field
  26. How can I generate a round robin tournament in PHP and MySQL?
  27. Add Prefix to auto-increment in mysql db
  28. Why cannot the PHP hide the error message thrown by the MySQL connection?
  29. MySQL Join Multiple Rows as Columns
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment