//如果数据表中有代表输入时间的insertdate字段，基本可以实现
//首先取得前两天的日期：
$yesterday=date("Y-m-d H:i:s",strtotime('-1 day'));
$thedaybeforeyesterday=date("Y-m-d H:i:s",strtotime('-2 day'));
$sql=" SELECT * FROM yourtable WHERE insertdate between $yesterday and $thedaybeforeyesterday order by id asc";
0 
2
1415
![ThinkPHP5快速开发企业站点[全程实录]](https://img.php.cn/upload/course/000/000/068/6253d918a3ce7278.png)
收藏
SELECT *FROM Table WHERE datediff(now(),'你表里的日期字段')=2
//如果数据表中有代表输入时间的insertdate字段，基本可以实现 //首先取得前两天的日期： $yesterday=date("Y-m-d H:i:s",strtotime('-1 day')); $thedaybeforeyesterday=date("Y-m-d H:i:s",strtotime('-2 day')); $sql=" SELECT * FROM yourtable WHERE insertdate between $yesterday and $thedaybeforeyesterday order by id asc";