[php] WHERE IN을 교리 2와 함께 사용하는 방법

나에게 오류를 제공하는 다음 코드가 있습니다.

Message: Invalid parameter number: number of bound variables does not match number of tokens 

암호:

public function getCount($ids, $outcome)
{
    if (!is_array($ids)) {
        $ids = array($ids);
    }
    $qb = $this->getEntityManager()->createQueryBuilder();
    $qb->add('select', $qb->expr()->count('r.id'))
       ->add('from', '\My\Entity\Rating r');
    if ($outcome === 'wins') {
        $qb->add('where', $qb->expr()->in('r.winner', array('?1')));
    }
    if ($outcome === 'fails') {
        $qb->add('where', $qb->expr()->in('r.loser', array('?1')));
    }
    $qb->setParameter(1, $ids);
    $query = $qb->getQuery();
    //die('q = ' . $qb);
    return $query->getSingleScalarResult();
}

데이터 (또는 $ ids) :

Array
(
    [0] => 566
    [1] => 569
    [2] => 571
)

DQL 결과 :

q = SELECT COUNT(r.id) FROM \My\Entity\Rating r WHERE r.winner IN('?1')

답변

$qb->add('where', $qb->expr()->in('r.winner', array('?1')));

$qb->add('where', $qb->expr()->in('r.winner', '?1'));

$queryBuilder->andWhere('r.winner IN (:ids)')
             ->setParameter('ids', $ids);

$qb->andWhere('foo.field IN (:string)');
$qb->setParameter('string', array('foo', 'bar'), \Doctrine\DBAL\Connection::PARAM_STR_ARRAY);

$ids = array(...); // Array of your values
$qb->add('where', $qb->expr()->in('r.winner', $ids));

 $qb->andWhere('foo.field IN (:ints)');
 $qb->setParameter('ints', array(1, 2),
 \Doctrine\DBAL\Connection::PARAM_INT_ARRAY);

// Symfony example
$ids    = [1, 2, 3, 4];
$repo   = $this->getDoctrine()->getRepository('AppBundle:RepoName');
$result = $repo->findBy([
    'id' => $ids
]);

$values = array(...); // array of your values
$qb->andWhere('where', $qb->expr()->in('r.winner', $values));