我正在使用doctrine DBAL,由于queryBuilder的结果,SQL查询出现了一些问题。
$builder = $this->getConnection()->getQueryBuilder();
$builder->select(['id','name','type'])
->from('table')
->where('id='.(int)$value)
->setMaxResults(1);
$builder->andWhere($builder->expr()->in('type', ['first','second']));
echo(builder->getSQL());
$data = $builder->execute()->fetchRow();
查询SQL
SELECT id, name, type FROM table WHERE (id=149) AND (type IN (first,second)) LIMIT 1
这就是问题所在,我需要将(type IN (first,second))编码为字符串(type IN ('first','second'))
如何以正确的方式使用查询生成器?
Try with
$builder->andWhere('type IN (:string)');
$builder->setParameter('string', ['first','second'], 'Doctrine'DBAL'Connection::PARAM_STR_ARRAY);
$builder
->andWhere($builder->expr()->in('type', ':types'))
->setParameter(':types', ['first','second'], 'Doctrine'DBAL'Connection::PARAM_STR_ARRAY);