本文介绍了具有数组值的 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
这就是问题所在，我需要将 (type IN (first,second)) 编码为字符串，例如 (type IN ('first','second'))
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'), DoctrineDBALConnection::PARAM_STR_ARRAY);
这篇关于具有数组值的 Doctrine DBAL setParameter()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！