PHP Mongodb Count Result

Question

I'm performing a simple request to my MongoDB in php. It looks like this:

$result = $this->myMongoClient->myCollection->find([
    'param_1' => $param_1,
    'param_2' => $param_2,
]);

This returns a MongoDB\Driver\Cursor object. I need the count of returned entrys from the database.

I've googeld a while and found this. But with this function dose not exists on the object returend by MongoDB (Call to undefined method MongoDB\Driver\Cursor::count())

$result->count()

Which is the commun way to count the number of results?

score 1 · Answer 1 · answered May 13 '19 at 19:51

1

I have found a solution, but don't know if it is recommendable or not.

count($result->toArray());

answered May 13 '19 at 19:51

Markus

1,909
4
26
54

That's going to pull all of the data for the result set out of the database instead of just executing a count on the data in the DB. – Wedge Martin May 13 '19 at 19:52
Is there an alternative? – Markus May 13 '19 at 19:53
Some alternatives here: https://stackoverflow.com/questions/36726069/how-to-get-cursor-result-count-using-the-mongodb-php-extension – Wedge Martin May 13 '19 at 20:26

score 0 · Answer 2 · answered May 13 '19 at 21:24

0

I don't know if you are using the MongoDB PHP Library, but if you are you can just use the following

$result = $this->myMongoClient->myCollection->countDocuments($where);

https://docs.mongodb.com/php-library/master/reference/method/MongoDBCollection-countDocuments/index.html

answered May 13 '19 at 21:24

Trevor Geene

479
3
12

Yes i'm using the offical php library. With this solution I have to send two requests to the database one to get the documents and one to count them. Am I right? – Markus May 13 '19 at 21:26
Yes, this method would require you to make 2 separate calls to the database if you wanted both a document count and the documents themselves. – Trevor Geene May 13 '19 at 21:30

PHP Mongodb Count Result

2 Answers2