具有数组值的 Doctrine DBAL setParameter() [英] Doctrine DBAL setParameter() with array value

问题描述

我正在使用学说 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()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！