how can sort group by result in PHP MongoDB

Question

in php i have created a cursor which hold group by result from MongoDB with following command.

$m = new MongoClient();
$db = $m->Forensic;
$c= $db->mobile_data;

// JavaScript function to perform
$reduce = "function (obj, prev) { prev.count++; }";

//group by source (number of messages);
$d = $c->group( ["Source" => 1], ["count" => 0], $reduce);

how can I sort my result based on "Source" key.

Thnaks

Community · Accepted Answer · 2017-05-23 12:01:52Z

0

I would refer you to this question and see if that helps. There is also a link to the MongoDB documentation that might help you as well. There is also a decent explanation here also.

I'm just dabbling in group and sort in MongoDB myself.

One example I found was;

db.orders.aggregate([
   {
     $group: {
        _id: "$cust_id",
        count: { $sum: 1 }
     }
   },
   { $match: { count: { $gt: 1 } } }
])

and there is also a similar thread here as well.

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Jan 11, 2017 at 20:29

user5487958

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

3 Comments

Sumon Over a year ago

Thank you for your answer but I know how to sort result from mongodb platform, but currently I am passing my command from php. how to write code in php group by sort would be much appreciate

user5487958 Over a year ago

In PHP or on SQL?

Sumon Over a year ago

PHP commad like $d = $c->group( ["Source" => 1], ["count" => 0], $reduce, Sort("Source"));

Sumon · Accepted Answer · 2017-01-12 22:39:58Z

0

Found an alternative solution

$m = new MongoClient();
$db = $m->Forensic;
$c= $db->mobile_data;

// JavaScript function to perform
$reduce = "function (obj, prev) { prev.count++; }";

//group by source (number of messages);
$d = $c->group( ["Source" => 1], ["count" => 0], $reduce);

//sort record
sort($d['retval']);

which will sort by Source field

answered Jan 12, 2017 at 22:39

Sumon

2998 silver badges18 bronze badges

Collectives™ on Stack Overflow

how can sort group by result in PHP MongoDB

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related