查询从symfony教条中的多个表中获取多列

Question

我想从多个表中获取数据，但是我没有在symfony3教条中得到正确的查询。请帮帮我。

我写了我的教训查询如下 -

$q = $this-> getDoctrine()-> getManager(); 
     $query = $q->createQuery(' 
      SELECT p.firstname , p.lastname , l.language 
        from UserBundle:Post p 
        from UserBundle:Language l 
        from UserBundle:UserLanguage u 
        where p.id = u.id and l.id = u.languageid 
      '); 

     return $queryBuilder->getQuery()->getResult(); 
} 

Answer 1

我终于能够解决这一问题。这是在给定条件下从多个表中获取不同列的dql查询。

$em = $this -> getDoctrine()->getManager(); 
$res = $em->createQuery(' SELECT p.firstname , p.lastname , l.language from UserBundle:Post p Join UserBundle:UserLanguage u with p.id = u.userid join UserBundle:Language l with l.id = u.languageid'); 
$result = $res->getResult(); 

return $this->render('UserBundle:Default:showLanguage.html.twig', array('user' => $result));