我正在尝试进行DQL查询,但遇到了一些问题…
$user = $this->getUser();
$query = $em->createQuery(
'SELECT p
FROM AppBundle:User u
JOIN AppBundle:Follower f
JOIN AppBundle:Photo p
WHERE u.id = :id
AND f.follower_id = :id
AND p.user_id = f.user_id'
)->setParameter('id', $user->getId());
我正在尝试获取这些用户的照片(AppBundle:Photo
),登录用户正在关注这些用户。
获取下一个错误:
`[Syntax Error] line 0, col 128: Error: Expected =, <, <=, <>, >, >=, !=, got 'p'`
"p"怎么了?
我不明白为什么follower
会出现在您的代码中,我看不到与photo
的关系
之后,我想你打电话给Join
,但我看不出你与照片的关系
$query = $em->createQuery(
'SELECT p
FROM AppBundle:Photo p
JOIN p.user u
WHERE u.id = :id ')->setParameter('id', $user->getId());
以下是官方文档的一部分:示例:
定期加入地址:
createQuery("SELECT u FROM User u JOIN u.address"WHERE a.city='Berlin'");$users=$query->getResult();
获取地址的联接:
createQuery("SELECT u,a FROM User u JOINu.address a WHERE a.city="Berlin");$users=$query->getResult();
你试过这个吗?:
$query = $em->createQuery(
'SELECT p
FROM AppBundle:Photo p
JOIN AppBundle:Follower f
JOIN AppBundle:User u
WHERE u.id = :id
AND f.follower_id = :id
AND p.user_id = f.user_id' )->setParameter('id', $user->getId());