如何将mongoDB shell查询转换为php

Question

How to Convert mongoDB Query to php

db.getCollection('xyz').aggregate({ $match: { 
$and: [ 
{ created_at: { $gt:new ISODate("2016-07-05"), $lt:new ISODate("2016-09-05") }, id: "1" } 
] 
} }, 
{ $group: { _id : "distance", sum : { $sum: "$distance" } } });

Answer 1

Check the code below which used to connect mongodb with php.

$m = new MongoClient();
$db = $m->yourDB;

$collection = $db->yourCollecton;

$sdate = '2016-01-01';
$sdate = '2016-01-31';

$pipeline = array(
    array(
        '$match'=>array('date'=>array('$gte'=>$sdate,'$lte'=>$edate))       
    ),
    array(
         '$group' => array(
            '_id' => array(null),
            'first_field' => array('$field'),
          )
    )
);

$cursor = $collection->aggregate($pipeline);
$row  = $cursor['result'][0];