本文介绍了具有数组值的Doctrine DBAL setParameter()的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用的是教义DBAL,并且由于queryBuilder而导致SQL查询出现问题.
I'm using doctrine DBAL and have some problem with SQL query as result of a queryBuilder.
$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
这是问题所在,我需要将(类型IN(第一,第二))编码为类似(类型IN(第一,第二"))的字符串
And this is the problem, I need that (type IN (first,second)) was encoded as strings like (type IN ('first','second'))
如何用正确的方式使用查询生成器?
How to do that with query builder in the right way?
推荐答案
尝试使用
$builder->andWhere('type IN (:string)');
$builder->setParameter('string', array('first','second'), \Doctrine\DBAL\Connection::PARAM_STR_ARRAY);
这篇关于具有数组值的Doctrine DBAL setParameter()的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!