如何在php中获取更新日期小于30天的所有记录 [英] How to get all the records whose updated date is less than 30 days in php

问题描述

我想从 mysql 数据库中获取从当前日期起 30 天内更新记录的所有记录，因为我使用了以下查询，但它无法正常工作.$tda 是当前日期，$prevmonth 是确切日期从当前日期回溯 30 天.请帮忙.谢谢.

I want to get all the records from mysql database who have updated their records within 30 days from the current date for that i have used the below query but it is not working properly. $tda is the current date and $prevmonth is the date of exactly 30 days back from the current date. Please help. Thanks.

$da=date('d');
$tda=date('d-m-Y');
$prevmonth = date(''.$da.'-m-Y', strtotime('-1 months'));
$sql_q=executeQuery("select * from ".reg." where 'uid' !=".$_SESSION['uid']." AND Updatedate >= '$prevmonth' AND  Updatedate <='$tda '");

推荐答案

你可以在mysql中做

You can do it in mysql as

`Updatedate` <  DATE(NOW() - INTERVAL 30 DAY)

或

`Updatedate` <  DATE_SUB(CURDATE(), INTERVAL 30 DAY)

对于 Varchar

For Varchar

 STR_TO_DATE(Updatedate, '%Y-%m-%d') <  DATE_SUB(CURDATE(), INTERVAL 30 DAY)

更新:

评论中发布的查询是错误的，应该是

The query posted in the comment is wrong and should be

$sql_q=executeQuery("select * from registration
where 
`uid` != ".$_SESSION['uid']." 
AND STR_TO_DATE(Update_date, '%d-%m-%Y') < DATE_SUB(CURDATE(), INTERVAL 30 DAY)") ;

如果您要查找过去 30 天内的数据，则

If you are looking for data within last 30 days then

$sql_q=executeQuery("select * from registration
where 
`uid` != ".$_SESSION['uid']." 
AND STR_TO_DATE(Update_date, '%d-%m-%Y') >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)") ;

这篇关于如何在php中获取更新日期小于30天的所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！