tp5查询当天数据、分组查询当天数据

zmlucky

已于 2025-04-19 11:25:37 修改

阅读量6.2k

点赞数 5

分类专栏： PHP SQL 文章标签： sql php

于 2020-03-26 17:32:18 首次发布

本文链接：https://blog.csdn.net/weixin_44506318/article/details/105123683

版权

PHP 同时被 2 个专栏收录

50 篇文章

订阅专栏

SQL

7 篇文章

订阅专栏

//当天数据
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$endToday=mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;
$map['create_time'] = array('between', array($beginToday,$endToday));


//昨天数据          
$beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$endYesterday=mktime(0,0,0,date('m'),date('d'),date('Y'))-1;
$map['create_time'] = array('between', array($beginYesterday,$endYesterday));

//按日期和分类  分组查询  
//create_time 字段在数据库里为时间戳

$list = M('user')->where($map)
                ->field("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d') as date,count(*) as total,type")
                ->group("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d'),type") 
                ->select();
$list = array_reverse($list);


 //create_time 字段在数据库里为年月日
$result = Db::name('orders')
            ->field('DATE_FORMAT(create_time, "%Y-%m") as month, COUNT(*) as count')
            ->group('month')
            ->select();
 




//ip地址过滤
$distinct_click_ip_list = M('user')
        ->where(array('type'=>1))
        ->field("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d') as date,count(distinct create_ip) as distinct_total,type")
        ->group("DATE_FORMAT(FROM_UNIXTIME(create_time),'%Y-%m-%d'),type")
        ->select();