php - 我将如何在 Doctrine2 中执行 MySQL 计数(*)？

Question

我有以下 Doctrine2 查询:

$qb = $em->createQueryBuilder()
      ->select('t.tag_text, COUNT(*) as num_tags')
      ->from('CompanyWebsiteBundle:Tag2Post', 't2p')
      ->innerJoin('t2p.tags', 't')
      ->groupBy('t.tag_text')
;
$tags = $qb->getQuery()->getResult();

运行时出现如下错误:

[Semantical Error] line 0, col 21 near '*) as num_tags': Error: '*' is not defined. 

我将如何在 Doctrine2 中执行 MySQL count(*)？

Answer 1

您应该能够像这样(将查询构建为字符串):

$query = $em->createQuery('SELECT COUNT(u.id) FROM Entities\User u');
$count = $query->getSingleScalarResult();