2025年02月12日 建站教程
如何利用php语法查询指定时间段内数据库中的数据，下面web建站小编给大家简单介绍一下具体代码！
实现代码如下：
$month = '01';
$year = '2023';
$max_day = cal_days_in_month(CAL_GREGORIAN, $month, $year); //当月最后一天
$min = $year.'-'.$month.'-01 00:00:00';
$max = $year.'-'.$month.'-'.$max_day.' 23:59:59';
$sql = "select t.enterdate,count(*) as total_num,sum(t.total_price) as amount (select date_format(enterdate,'%e') as enterdate,total_price from orders where enterdate between {$min} and {$max}) t group by t.enterdate order by t.enterdate";
$return = mysqli_query($sql);
本文链接：http://so.lmcjl.com/news/23007/