thinkphp 查询数据库数据根据两个字段group，且统计条数用法

最新推荐文章于 2023-01-11 09:55:22 发布

hexiaoniao

最新推荐文章于 2023-01-11 09:55:22 发布

阅读量1.3w

点赞数 2

分类专栏： php 文章标签： thinkphp group TP框架

本文链接：https://blog.csdn.net/hexiaoniao/article/details/56479748

版权

php 专栏收录该内容

100 篇文章 0 订阅

订阅专栏

$result=M('sale_lead')
    ->field('lead_source,created_by,count(sale_lead_id ) as count_num')
    ->group('lead_source,created_by')
    ->where($where)
    ->select();

结果：

array(14) {
  [0] => array(3) {
    ["lead_source"] => string(1) "1"
    ["created_by"] => string(2) "42"
    ["count_num"] => string(1) "1"
  }
  [1] => array(3) {
    ["lead_source"] => string(1) "3"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "1"
  }
  [2] => array(3) {
    ["lead_source"] => string(1) "4"
    ["created_by"] => string(2) "29"
    ["count_num"] => string(1) "2"
  }
  [3] => array(3) {
    ["lead_source"] => string(1) "5"
    ["created_by"] => string(2) "29"
    ["count_num"] => string(1) "1"
  }
  [4] => array(3) {
    ["lead_source"] => string(1) "5"
    ["created_by"] => string(2) "42"
    ["count_num"] => string(1) "1"
  }
  [5] => array(3) {
    ["lead_source"] => string(1) "6"
    ["created_by"] => string(2) "29"
    ["count_num"] => string(1) "2"
  }
  [6] => array(3) {
    ["lead_source"] => string(1) "7"
    ["created_by"] => string(2) "42"
    ["count_num"] => string(1) "1"
  }
  [7] => array(3) {
    ["lead_source"] => string(1) "7"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "2"
  }
  [8] => array(3) {
    ["lead_source"] => string(1) "8"
    ["created_by"] => string(2) "42"
    ["count_num"] => string(1) "5"
  }
  [9] => array(3) {
    ["lead_source"] => string(1) "8"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "2"
  }
  [10] => array(3) {
    ["lead_source"] => string(2) "13"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "1"
  }
  [11] => array(3) {
    ["lead_source"] => string(2) "43"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "2"
  }
  [12] => array(3) {
    ["lead_source"] => string(2) "44"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "1"
  }
  [13] => array(3) {
    ["lead_source"] => string(2) "45"
    ["created_by"] => string(2) "43"
    ["count_num"] => string(1) "1"
  }
}