SQL query in symfony2 and doctrine2

Question

i'm trying to create a SQL query in Doctrine 2 (Symfony2 Framework), and i need some help. I have two Tables Movie and Person in relation many to many in table Movie_Person.

I want to get a Persons who plays in film. So clear SQL should look like:

SELECT p.* FROM Person p WHERE EXISTS 
                (SELECT m.* FROM Movie_Person m WHERE p.id = m.person_id)

How to write this in Symfony2 + Doctrine2 ?

greg0ire · Accepted Answer · 2011-11-18 22:57:49Z

6

Example taken from the docs:

$query = $em->createQuery('SELECT u.id 
                             FROM CmsUser u 
                            WHERE EXISTS (SELECT p.phonenumber 
                                            FROM CmsPhonenumber p 
                                           WHERE p.user = u.id)');
$ids = $query->getResult();

Important note: Remember, this is NOT SQL. It's DQL. The main difference is you operate on objects and properties as opposed to database tables and fields.

edited Nov 18, 2011 at 22:57

greg0ire

23.3k17 gold badges76 silver badges104 bronze badges

answered Nov 18, 2011 at 22:34

Jakub Zalas

36.3k10 gold badges98 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query in symfony2 and doctrine2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related