Symfony2 Doctrine get count all as integer

Question

I want to get count of all records in DB. I haven't found one recommended way to do this. So I've built in my entity repo this function:

public function countAll()
{
    return $this->createQueryBuilder('post')
        ->select('COUNT(post)')
        ->getQuery()->getSingleScalarResult()
        ;
}

and it's OK, because it returns me count of all items. I use FOSRestBundle, so my action in controller looks like:

public function getPostsCountAction() {
    return $this->em->getRepository('KamilTestBundle:Post')->countAll();
}

and result at the addres posts/count.json looks like:

"16"

But... I want to take this value as integer. I don't know why QueryBuilder returns it as string. Even if I use ->getQuery()->getResult() and dump this output it's also string, not integer.

How can I take this value as integer? It is possible?

see stackoverflow.com/a/9215880/1794894

Rvanlaak
– Rvanlaak

2015-11-10 10:50:08 +00:00
Commented Nov 10, 2015 at 10:50 — Rvanlaak
– Rvanlaak, Commented Nov 10, 2015 at 10:50

Stefan Gehrig · Accepted Answer · 2015-11-10 11:04:34Z

6

intval() will return the number representation of a string.

While it might be a slippery thing to use this, you should be 100% fine since you know you will be getting only numbers.

public function countAll()
{
    return intval($this->createQueryBuilder('post')
        ->select('COUNT(post)')
        ->getQuery()->getSingleScalarResult());
}

edited Nov 10, 2015 at 11:04

Stefan Gehrig

83.9k24 gold badges162 silver badges193 bronze badges

answered Nov 10, 2015 at 10:26

Andrius

5,94922 silver badges28 bronze badges

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

3 Comments

Kamil P Over a year ago

Mhm, when I use "COUNT(post)" it always will be integer. But maybe I can do this with doctrine. For example: when I take complete entity id's of records are integers.

Andrius Over a year ago

Doesn't my answer solve it? What other problems are you having?

qooplmao Over a year ago

Or return (int) $this->createQueryBuilder('post')....->getSingleScalarResult().

George Irimiciuc · Accepted Answer · 2015-11-10 10:48:48Z

-3

return count($this->em->getRepository('KamilTestBundle:Post')->findAll());

This should return an integer (count).

An alternative could be typecasting:

 return (int) $this->em->getRepository('KamilTestBundle:Post')->countAll();

This will just convert your string to an int and should be more efficient than counting in PHP.

edited Nov 10, 2015 at 10:48

answered Nov 10, 2015 at 10:31

George Irimiciuc

4,64110 gold badges49 silver badges89 bronze badges

4 Comments

Kamil P Over a year ago

Yes, but this solution isn't good idea. It's OK when i have 16 posts, but when it will be number like 16000? It doesn't make sense to take all posts and count it on PHP side.

George Irimiciuc Over a year ago

True, but you didn't specify you have such a large number of entries. Lettings the db query count them is the better idea in this case.

Kamil P Over a year ago

I don't know how many entities I will have in future :) I always prefer to count items with DB query.

George Irimiciuc Over a year ago

Try typecasting as I suggested, see if it works. I don't understand why I am getting downvotes for a plausible answer.

Collectives™ on Stack Overflow

Symfony2 Doctrine get count all as integer

2 Answers 2

3 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related