PHP中的mongodb group操作实例(2)
复制代码 代码如下: db.fruit.group( { key: { category: 1}, cond: { _id: { $gt: 2 } }, reduce: function(obj, prev) { prev.items.push(obj.name); prev.count++; }, initial: { items : [] ,count:0} }
复制代码 代码如下:
> db.fruit.group(
{
key: { category: 1},
cond: { _id: { $gt: 2 } },
reduce: function(obj, prev) {
prev.items.push(obj.name);
prev.count++;
},
initial: { items : [] ,count:0}
}
);
[
{
"category" : "fruit",
"items" : [
"banana"
],
"count" : 1
},
{
"category" : "veggie",
"items" : [
"corn",
"broccoli"
],
"count" : 2
}
]
php代码如下：
复制代码 代码如下:
$keys = array("category" => 1);
$initial = array("items" => array(),'count'=>0);
$reduce = "function (obj, prev) { " .
"prev.items.push(obj.name); " .
"prev.count++;" .
"}";
$condition = array('condition' => array("_id" => array( '$gt' => 2)));
$g = $collection->group($keys, $initial, $reduce, $condition);
print_r($g); //结果如下。
Array
(
[retval] => Array
(
[0] => Array
(
[category] => fruit
[items] => Array
(
[0] => banana
)
[count] => 1
)
[1] => Array
(
[category] => veggie
[items] => Array
(
[0] => corn
[1] => broccoli
)
[count] => 2
)
)
[count] => 3
[keys] => 2
[ok] => 1
)
3、利用aggregate group功能，也挺强大
- 上一篇：mongodb设置后台运行的方法
- 下一篇：C#实现窗体中的各个控件同比自动放缩大小
精彩图集
精彩文章