Dctrine DQL动态ORDER BY参数

问题描述：

我正在尝试将ORDER BY列作为DQL中的参数传递，如下所示:

Im trying to pass the ORDER BY column as a parameter in DQL, like below:

$this->em->createQuery("SELECT t FROM Entities\Topic t ORDER BY :order")
     ->setParameters( array('order' => 't.name') )->getResult();

我猜这是行不通的，因为setParameter将转义:order，但是下面的解决方案似乎不太好:

I guess it doesn't work because setParameter will escape :order, however the below solution doesn't seem very good:

$order = 't.name'; // Dynamic value
$this->em->createQuery("SELECT t FROM Entities\Topic t ORDER BY $order")
     ->getResult();

有没有更好的方法来解决这个问题?

Is there a better way to solve this?

答

在这种情况下，请使用教义

In that case use Doctrines Querybuilder:

$order = 't.name'; // Dynamic value

$qb = $this->_em->createQueryBuilder();
$qb->select('t')
   ->from('Entities\Topic', 't')
   ->orderBy($order);