php中mongodb如何分组查询请平均数和总和?
网友回复
使用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%