php如何对mongodb最近几日数据分组统计?例如统计近7日每天新增用户量。
网友回复
首先插入mongodb数据库中的字段为int时间戳格式,然后通过project转换成日期格式,示例代码如下:
<?php
$manager = new MongoDB\Driver\Manager("mongodb://localhost:27017");
// 插入数据
$bulk = new MongoDB\Driver\BulkWrite;
$bulk->insert(['x' => 2, 'name' => 'bfw', 'scores' => 123, 'atime' => time()-1000000]);
$bulk->insert(['x' => 2, 'name' => 'google', 'scores' => 10, 'atime' => time()-200000]);
$bulk->insert(['x' => 2, 'name' => 'baidu', 'scores' => 11, 'atime' => time()-1231123]);
$bulk->insert(['x' => 2, 'name' => 'bfw', 'scores' => 200, 'atime' => time()]);
$bulk->insert(['x' => 2, 'name' => 'bfw', 'scores' => 123, 'atime' => time()]);
$bulk->insert(['x' => 2, 'name' => 'google', 'scores' => 10, 'atime' => time()]);
$bulk->insert(['x' => 2, 'name' => 'baidu', 'scores' => 11, 'atime' =>...点击查看剩余70%


