PHP
2023-06-07 14:05
53
0
查询最近30天记录
date_default_timezone_set('Etc/GMT-8'); //校正时区
$last_day = date('Y-m-d H:i:s', time() - 60*60*24*30); //生成日期
$sql = "select * from `table` where `add_time` >= '".$last_day."'";
$time = strtotime('-30 day');
$sql = 'select * from table where add_time >='.$time
mysql_query($sql);
