Symfony QueryBuilder count request returns "array"

Question

I'm trying to make a count request on an id field.

I have the following code in my controller:

$qb = $em->createQueryBuilder();
$qb->select('count(c.id)')
        ->from('MyBundle:Category', 'c')
        ->where('c.author = :aut')
        ->setParameter('aut', $author);

$result = $qb->getQuery()->getResult();

return $this->render('MyCategoryBundle:Category:categories.html.twig', array(
       'categories' => $categories,
       'result' => $result
    ));

And in my view.html.twig :

{% for category in categories %}      
       <li>
           {{ category.title }} 
           {% for total in  result %}
                {{ total }}
           {% endfor %}
      </li>          
{% endfor %}

It returns the category title and the string "Array" just besides. What am I doing wrong ?

A.L · Accepted Answer · 2018-12-19 12:48:50Z

3

The getResult() returns an array (collection) of objects. You have to use the getSingleScalarResult() function in order to get the result as a simple number.

Anyway, what is the goal of your code? If you want to display the number of categories for each author, your code may not work since you display a list of categories but you only count the categories from one author.

edited Dec 19, 2018 at 12:48

answered Nov 29, 2013 at 11:37

A.L

10.6k10 gold badges73 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2094540 Over a year ago

Oh ok, I didn't knew that. Yes, I want to display the number of categories for one author. I get its id with the $author var.

A.L Over a year ago

So why do you use a for loop on the categories?

user2094540 Over a year ago

That was due to my array results using getResults(). I was wrong indeed. It works with getSingleScalarResult() and removing the loop in the view. Thanks for your help and explanation !

repincln · Accepted Answer · 2013-11-29 12:44:46Z

0

Try this:

$qb = $em->createQueryBuilder();
$qb->select('count(c.id) AS cnt')
        ->from('MyBundle:Category', 'c')
        ->where('c.author = :aut')
        ->setParameter('aut', $author);

$result = $qb->getQuery()->getResult();

and then in twig {{result.cnt}}

edited Nov 29, 2013 at 12:44

answered Nov 29, 2013 at 11:44

repincln

2,0595 gold badges25 silver badges35 bronze badges

Collectives™ on Stack Overflow

Symfony QueryBuilder count request returns "array"

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related