{"id":392,"title":"php7\u4e2d\u4f7f\u7528mongodb\u7684aggregate\u8fdb\u884c\u805a\u5408\u64cd\u4f5c(sum\u6c42\u548c,avg\u7b49)","good":45,"bad":9,"hit":8559,"created_at":"2018-08-13 00:23:56","content":"<p>\u4e4b\u524d\u5199\u7684php\u64cd\u4f5cmongodb\u7c7b\u4e2d\u6ca1\u6709\u5b9e\u73b0\u805a\u5408\u64cd\u4f5c\uff0c\u7814\u7a76\u4e86\u597d\u4e45\uff0c\u5728\u547d\u4ee4\u884c\u4e0b\u53ef\u4ee5\u6b63\u5e38\uff0c\u4f46\u662f\u7528php\u5199\u7684\u7ed3\u679c\u4e0e\u547d\u4ee4\u884c\u4e0d\u4e00\u6837\uff0c\u6298\u817e\u4e86\u597d\u4e45\uff0c\u53d1\u73b0\u662f\u5199\u6cd5\u9519\u4e86\uff0c\u6700\u540e\u5728php\u5b98\u7f51\u4e2d\u627e\u5230\u89e3\u51b3\u529e\u6cd5\uff0c\u4e4b\u524d\u5728\u7f51\u4e0a\u770b\u5230\u7684\u90fd\u662f\u8001\u7684mongo\u64cd\u4f5c\u65b9\u6cd5\uff0c\u4e0d\u662fmongodb\uff0c\u770b\u6587\u6863\u771f\u7684\u5f88\u91cd\u8981\uff1a<\/p><p><br\/><\/p><p>7 aggregate\u4f7f\u7528\uff0c\u76f8\u5f53\u4e8eshell\u91cc\u9762\u7684\u201d|\u201d&nbsp;<\/p><p>\u4e0a\u9762\u7684\u51e0\u4e4e\u5168\u90e8\u53ef\u4ee5\u7528aggregate\u8fdb\u884c\u67e5\u8be2&nbsp;<\/p><p>\u4e0esql\u5bf9\u5e94\u5173\u7cfb<\/p><p><br\/><\/p><p>sql &nbsp; &nbsp; &nbsp; &nbsp; mongodb<\/p><p><br\/><\/p><p>WHERE &nbsp; &nbsp; &nbsp; $match &nbsp;\/\/match\u91cc\u9762\u53ef\u4ee5\u7528and\uff0cor\uff0c\u4ee5\u53ca\u903b\u8f91\u5224\u65ad\uff0c\u4f46\u662f\u597d\u50cf\u4e0d\u80fd\u7528where<\/p><p>GROUP BY &nbsp; &nbsp;$group<\/p><p>HAVING &nbsp; &nbsp; &nbsp;$match<\/p><p>SELECT &nbsp; &nbsp; &nbsp;$project<\/p><p>ORDER BY &nbsp; &nbsp;$sort<\/p><p>LIMIT &nbsp; &nbsp; &nbsp; $limit<\/p><p>SUM() &nbsp; &nbsp; &nbsp; $sum<\/p><p>COUNT() &nbsp; &nbsp; $sum<\/p><p><br\/><\/p><p><img src=\"https:\/\/api.hu-rong.com\/uploads\/image\/20180815\/1534332538802847.png\" title=\"1534332538802847.png\" alt=\"blob.png\"\/><\/p><p><img src=\"https:\/\/api.hu-rong.com\/uploads\/image\/20180815\/1534332502213944.png\" title=\"1534332502213944.png\" alt=\"blob.png\"\/><\/p><pre class=\"brush:php;toolbar:false\">&gt;&nbsp;db.users.aggregate([{$group:{&quot;_id&quot;:&quot;$type&quot;,&quot;hr_count&quot;:{&quot;$sum&quot;:1}}}]);\n{&nbsp;&quot;_id&quot;&nbsp;:&nbsp;&quot;wn&quot;,&nbsp;&quot;hr_count&quot;&nbsp;:&nbsp;1&nbsp;}\n{&nbsp;&quot;_id&quot;&nbsp;:&nbsp;&quot;bt&quot;,&nbsp;&quot;hr_count&quot;&nbsp;:&nbsp;3&nbsp;}\n{&nbsp;&quot;_id&quot;&nbsp;:&nbsp;&quot;ns&quot;,&nbsp;&quot;hr_count&quot;&nbsp;:&nbsp;3&nbsp;}\n{&nbsp;&quot;_id&quot;&nbsp;:&nbsp;null,&nbsp;&quot;hr_count&quot;&nbsp;:&nbsp;6&nbsp;}\n&gt;<\/pre><p><br\/><\/p><p>Php\u5b98\u65b9\u6587\u6863\u793a\u4f8b\uff1a<\/p><p><a href=\"http:\/\/www.php.net\/manual\/zh\/mongodb-driver-manager.executecommand.php\">http:\/\/www.php.net\/manual\/zh\/mongodb-driver-manager.executecommand.php<\/a> <\/p><p>mongodb\u5b98\u65b9\u5173\u4e8epipeline\u7684\u8bf4\u660e\uff1a<\/p><p><a href=\"https:\/\/docs.mongodb.com\/manual\/core\/aggregation-pipeline\/\">https:\/\/docs.mongodb.com\/manual\/core\/aggregation-pipeline\/<\/a> <\/p><p><br\/><\/p><p><\/p><p>php\u4f7f\u7528aggregate\u64cd\u4f5cmongodb\u8fdb\u884c\u6c42\u548c\u793a\u4f8b\uff1a\u4e4b\u524d\u4e00\u76f4\u6ca1\u5199pipeline,\u628agroup\u653e\u5230\u4e0a\u4e00\u5c42\u53bb\u4e86\uff0c\u6240\u4ee5\u4e00\u76f4\u65e0\u6cd5\u5206\u7ec4\uff0c\u5751\u3002\u3002\u3002<\/p><pre class=\"brush:php;toolbar:false\">&lt;?php\n\/**\n&nbsp;*&nbsp;Created&nbsp;by&nbsp;PhpStorm.\n&nbsp;*&nbsp;User:&nbsp;www.hu-rong.com\n&nbsp;*&nbsp;Date:&nbsp;2018\/8\/12\n&nbsp;*&nbsp;Time:&nbsp;22:10\n&nbsp;*\/\n\n\n$manager&nbsp;=&nbsp;new&nbsp;MongoDB\\Driver\\Manager(&quot;mongodb:\/\/localhost:27017&quot;);\n\n\n$param&nbsp;=&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&#39;aggregate&#39;&nbsp;=&gt;&nbsp;&#39;users&#39;,\n&nbsp;&nbsp;&nbsp;&nbsp;&#39;pipeline&#39;&nbsp;=&gt;&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;$match&#39;&nbsp;=&gt;&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;price&#39;&nbsp;=&gt;&nbsp;[&#39;$gte&#39;&nbsp;=&gt;&nbsp;3600]\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;]\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;],\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;$group&#39;&nbsp;=&gt;&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;_id&#39;&nbsp;=&gt;&nbsp;&#39;$type&#39;,\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;hr_count&#39;&nbsp;=&gt;&nbsp;[\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#39;$sum&#39;&nbsp;=&gt;&nbsp;1\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;]\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;]\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;]\n\n&nbsp;&nbsp;&nbsp;&nbsp;],\n\n];\n$cmd&nbsp;=&nbsp;new&nbsp;MongoDB\\Driver\\Command($param);\n\/\/print_r($cmd);\nprint_r($manager-&gt;executeCommand(&#39;linux_hurong&#39;,&nbsp;$cmd)-&gt;toArray());<\/pre><p><br\/><\/p><p>\u7ed3\u679c\uff1a<\/p><p><br\/><\/p><pre class=\"brush:php;toolbar:false\">Array&nbsp;&nbsp;&nbsp;&nbsp;\n(&nbsp;&nbsp;&nbsp;&nbsp;\n[0]&nbsp;=&gt;&nbsp;stdClass&nbsp;Object&nbsp;&nbsp;&nbsp;&nbsp;\n(&nbsp;&nbsp;&nbsp;&nbsp;\n[waitedMS]&nbsp;=&gt;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;\n[result]&nbsp;=&gt;&nbsp;Array&nbsp;&nbsp;&nbsp;&nbsp;\n(&nbsp;&nbsp;&nbsp;&nbsp;\n[0]&nbsp;=&gt;&nbsp;stdClass&nbsp;Object&nbsp;&nbsp;&nbsp;&nbsp;\n(&nbsp;&nbsp;&nbsp;&nbsp;\n[_id]&nbsp;=&gt;&nbsp;bt&nbsp;&nbsp;&nbsp;&nbsp;\n[hr_count]&nbsp;=&gt;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;\n)&nbsp;&nbsp;&nbsp;&nbsp;\n[1]&nbsp;=&gt;&nbsp;stdClass&nbsp;Object&nbsp;&nbsp;&nbsp;&nbsp;\n(&nbsp;&nbsp;&nbsp;&nbsp;\n[_id]&nbsp;=&gt;&nbsp;ns&nbsp;&nbsp;&nbsp;&nbsp;\n[hr_count]&nbsp;=&gt;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;\n)&nbsp;&nbsp;&nbsp;&nbsp;\n)&nbsp;&nbsp;&nbsp;&nbsp;\n[ok]&nbsp;=&gt;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;\n)&nbsp;&nbsp;&nbsp;&nbsp;\n)<\/pre><p><br\/><\/p>"}