mysql 查询上月、本月、上周、本周、今日、昨日的充值额

su小猪猪

于 2018-05-21 11:28:16 发布

阅读量1k

点赞数 1

分类专栏： php mysql

本文链接：https://blog.youkuaiyun.com/fmbsly/article/details/80389959

版权

php 同时被 2 个专栏收录

9 篇文章

订阅专栏

mysql

1 篇文章

订阅专栏

本文介绍了一种通过SQL查询特定周期（包括上月、本月、上周、本周、今日及昨日）内的充值总额的方法。利用PHP mktime函数计算指定周期的开始时间，并据此构建SQL查询语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询上月、本月、上周、本周、今日、昨日的充值额

//查询上月、本月、上周、本周 、今日、昨日的充值额
$lastmonth  =  mktime(0,0,0,date('m')-1,1,date('Y'));  //上个月
$month = mktime(0,0,0,date('m'),1,date('Y')); //本月
$lastweek = mktime(0,0,0,date('m'),date('d')-date('w')-1+7,date('Y')); //上一周
$week = mktime(0,0,0,date('m'),date('d')-date('w')+1,date('Y'));//本周
$today = mktime(0,0,0,date('m'),date('d'),date('Y'));
$yesterday = $today - 86400;  //昨日

$sql = "select sum(rmb) as amount from recharge where create_time>=$month"; //本月
$sql = "select sum(rmb) as amount from recharge where create_time>=$today"; //查询今日
$sql = "select sum(rmb) as amount from recharge where create_time>=$week"; //查询本周
$sql = "select sum(rmb) as amount from recharge where create_time>=$lastmonth and create_time<$month"; //上月
$sql = "select sum(rmb) as amount from recharge where create_time>=$yesterday and create_time<$today"; //查询昨日
$sql = "select sum(rmb) as amount from recharge where create_time>=$lastweek and create_time<$week"; //查询上周