I have a MySQL table that contains datetime data stored in it. I need to know if 30 days has passed since the given time. How can I do this?
Mockup code:
$query = mysql_query("SELECT data FROM myTable LIMIT 1");
$row = mysql_fetch_array($query);
if( days_passed($row['date'], 30) )
echo "30 days has passed since the given date time.";
Answering the question directly, you can use this function in your if statement.
function days_passed($date, $days) {
$old = new DateTime($date);
$now = new DateTime();
$interval = $old->diff($now);
return ($interval->days >= $days);
}
That will return true if the difference between the date provided and now is >= the number of days supplied in the second argument.
However, your may prefer to do this with SQL.
$interval->days. $interval->d returns a number that is useful in statements like 1 month and 5 days.Altering your query to something like:
SELECT TIMESTAMPDIFF(DAY, `date`, NOW()) AS days_passed FROM myTable LIMIT 1
Will return the number of days since date.
SQLFiddle: http://sqlfiddle.com/#!2/015c9/2
You can just select the result right from the database;
SELECT *, ADDDATE(`date`, INTERVAL 30 DAY) < NOW() more_than_30_days_ago
FROM myTable LIMIT 1;
and then use something like;
if( $row['more_than_30_days_ago'] )
echo "30 days has passed since the given date time.";
Simple demo of the database part here.
$date = date('Y-m-d', strtotime('today + 30 days'));
$query = mysql_query("SELECT date FROM tbl WHERE date > '{$date}' LIMIT 1");
if (mysql_num_rows($query)) { ... }
In your question you're only pulling the data to check it, so really you don't even need to pull it. Just use a WHERE clause, and then if a row is pulled, you know it was found.
(If you actually need to process the data farther, or other conditions are involved, one of the other answers is probably better.)
Here is with PHP:
$days = 30;
if(date('Y-m-d', strtotime("{$row['date']} +{$days}day")) < date('Y-m-d'))
echo "More than 30 days has passed";
datefield?