MySQL数据库数据按月、按周分组

最新推荐文章于 2024-07-22 02:59:37 发布

zhu6201976

最新推荐文章于 2024-07-22 02:59:37 发布

阅读量7.8w

点赞数 1

分类专栏： PHP

本文链接：https://blog.csdn.net/zhu6201976/article/details/90106293

版权

PHP 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

有如下每日数据，如何按月、按周统计出具体数据？

PHP代码实现，核心是调用MySQL数据库提供的DATE_FORMAT()函数格式化时间（也可以是时间戳），变成自己想要的时间格式，再进行分组，最后再统计结果。

        // 按月分组
        $month_counts = Db::query('select DATE_FORMAT(date,"%Y-%m") as month,group_concat(count) as counts from jjb_user_count group by DATE_FORMAT(date,"%Y-%m");');
        foreach ($month_counts as &$value){
            $explodes = explode(",", $value['counts']);
            $value['counts'] = array_sum($explodes);
        }
        
        // 按周分组
        $week_counts = Db::query('select DATE_FORMAT(date,"%Y-%u") as week,group_concat(count) as counts from jjb_user_count group by DATE_FORMAT(date,"%Y-%u");');
        foreach ($week_counts as &$value){
            $explodes = explode(",", $value['counts']);
            $value['counts'] = array_sum($explodes);
        }