带有“或条件"的学说 FindBy 方法?

2022-01-16 00:00:00 php symfony doctrine doctrine-orm

是否可以在 Doctrine findBy() 方法中使用 OR 语句?

Is it possible to use OR statement in Doctrine findBy() method?

我希望输出是这样的:

SELECT * FROM `friends` WHERE userId=1 OR FriendId=1 ;

现在的代码:

$user = $repository->findBy(array(
            'userId' => $this->getRequest()->getSession()->get('id')
    );

推荐答案

我只会使用 DQL... 将这样的函数添加到您的存储库中:

I would just use DQL... Add a function like this to your repository:

public function findFriends($userId)
{
    return $this->getEntityManager()
        ->createQuery('SELECT f FROM Friends WHERE userId = :userId OR FriendId = :userId')
        ->setParameter('userId', $userId)
        ->getOneOrNullResult();
}

或者使用查询生成器代替 DQL:

Or use the query builder instead of DQL:

public function findFriends($userId)
{
    return $this->getEntityManager()
        ->createQueryBuilder()
        ->from('Friends', 'f')
        ->where('f.userId = :userId')
        ->orWhere('f.friendId = :userId')
        ->setParameter('userId', $userId)
        ->getQuery()
        ->getOneOrNullResult();
}

然后只需使用:

$user = $repository->findFriends($this->getRequest()->getSession()->get('id'));

相关文章