douhuan5073 2014-02-23 03:55
浏览 310
已采纳

PHP mongodb总和查询

MongoDB can not get the total.

MYSQL :

select sum(play) as toplam from videos

MongoDB :

    $group = $naytu->db->videos->group(array(), array("toplam" => 0), "function(obj, prev) {prev.toplam = prev.toplam + obj.play - 0;}"); 

results (print_r)

Array
(
[retval] => Array
    (
        [0] => Array
            (
                [toplam] => NAN
            )

    )

[count] => 78656
[keys] => 1
[ok] => 1
)

where is the problem ?

  • 写回答

3条回答 默认 最新

  • doudongfu8006 2014-02-23 10:53
    关注

    In PHP @Neils answer is:

    $mongo->videos->aggregate([
        ['$group' => ['_id' => null, 'toplam' => ['$sum' => '$play']]]
    ]);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 chaquopy python 安卓
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 CSS实现渐隐虚线框
  • ¥15 有没有帮写代码做实验仿真的
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥30 vmware exsi重置后登不上
  • ¥15 易盾点选的cb参数怎么解啊
  • ¥15 MATLAB运行显示错误,如何解决?
  • ¥15 c++头文件不能识别CDialog
  • ¥15 Excel发现不可读取的内容