aggregate query in mongodb in php returning null

Question

I ran this command in rockmongo tools- command and its returning correct values

{ 
    aggregate : "twits",                                
    pipeline : [
         {$group : {_id : "$by", num_tutorial : {$sum : 1}}}
    ]                
}

and then I tried to extract the values from it using this

 define("__COLLECTION_TWITS__","twits");

in /var/www/html/TradeTwits/require/config/DBConfig.inc.php

$collectionName=__COLLECTION_TWITS__;
$db = $this->connection("mo");
$col = $db->$collectionName;

return $col->aggregate(['$group'=> array('_id' => '$by','num_tutorial' => array($sum => 1))]);

in /var/www/html/TradeTwits/app/models/BaseModel.php

The above code should be returning all records grouped by usernames, but when in php ,it is not working fine.

Am using phalcon framework using PECL class library to access mongodb and rockmongo as GUI for accessing mongodb collection

It is returning correct values for find() count() etc.Should I use another library for aggregate or pipeline?

$sum should have simple quotes.

Constantin Guay
– Constantin Guay

2015-12-11 09:02:13 +00:00
Commented Dec 11, 2015 at 9:02 — Constantin Guay
– Constantin Guay, Commented Dec 11, 2015 at 9:02

Constantin Guay · Accepted Answer · 2015-12-11 09:04:36Z

3

Aggregate should be an array of arrays. I think here, you missed an array.

The documentation says:

$ops = array(
    array(
        '$project' => array(
            "author" => 1,
            "tags"   => 1,
        )
    ),
    array('$unwind' => '$tags'),
    array(
        '$group' => array(
            "_id" => array("tags" => '$tags'),
            "authors" => array('$addToSet' => '$author'),
        ),
    ),
);
$results = $c->aggregate($ops);

answered Dec 11, 2015 at 9:04

Constantin Guay

1,6642 gold badges16 silver badges27 bronze badges

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

1 Comment

shubhendu Over a year ago

Thanks a lot! :) A little bug was ruining it :)

Collectives™ on Stack Overflow

aggregate query in mongodb in php returning null

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related