php sql in条件查询,php – 带有IN子句的Symfony2.3原始sql查询

回答：

所以你做的至少有两个错误.第一个是@Alarid所说的：你不应该破坏你的阵列.第二个是在运行预准备语句时必须使用DoctrineDBALTypes Conversion for IN子句.

最后你的查询是这样的：

$stmt = $this->getDoctrine()->getEntityManager()

->getConnection()

->prepare('SELECT t1.id , t1.name , t2.start_date , t2.end_date

FROM table1 t1 , table2 t2

WHERE t1.id = t2.matchId AND t1.id IN (:ids)');

$stmt->bindValue('ids', $idSArray, \Doctrine\DBAL\Connection::PARAM_INT_ARRAY);

$stmt->execute();

或替代方案：

$stmt = $this->getDoctrine()->getEntityManager()

->getConnection()

->executeQuery('SELECT t1.id , t1.name , t2.start_date , t2.end_date

FROM table1 t1 , table2 t2

WHERE t1.id = t2.matchId AND t1.id IN (:ids)',

array('ids' => $idSArray),

array('ids' => \Doctrine\DBAL\Connection::PARAM_INT_ARRAY)

)

;