具有数组值的 Doctrine DBAL setParameter()

Doctrine DBAL setParameter() with array value(具有数组值的 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()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！