+
95
-

php中mongodb如何分组查询请平均数和总和?

php中mongodb如何分组查询请平均数和总和?

网友回复

+
15
-

使用aggregate,结合group及max min sum,具体代码如下:

<?php
$manager = new MongoDB\Driver\Manager("mongodb://localhost:27017");

// 插入数据
$bulk = new MongoDB\Driver\BulkWrite;

$bulk->insert(['x' => 2, 'name' =>'bfw','scores'=>123]);
$bulk->insert(['x' => 2, 'name' =>'google','scores'=>10]);
$bulk->insert(['x' => 2, 'name' =>'baidu','scores'=>11]);
$bulk->insert(['x' => 2, 'name' =>'bfw','scores'=>200]);
$_data=$manager->executeBulkWrite('test.sites2', $bulk);


...

点击查看剩余70%

我知道答案,我要回答