PHP check if date is 30 days in the past

php sql date back
Aart den Braber picture Aart den Braber · Nov 10, 2011 · Viewed 12.4k times · Source

I'm having a bit of a problem here.

I insert a date into the database: date_last_applied.

I can just call this by using $row['date_last_applied'], of course. Now, I need to check if this inserted date was 30 days ago and if so, execute an action.

$query = "SELECT date_last_applied FROM applicants WHERE memberID='$id'";
$result = mysql_query($query);

while($row = mysql_fetch_array($result)) {
    $date = strtotime($row['date_last_applied']);

}

That's about all I have.. I tried some things, but they all failed. :(

Answer

Brad picture Brad · Nov 10, 2011 
if ($date < strtotime('-30 days'))

If you are only performing actions on dates older than 30 days, you should use Marco's solution.

Related questions

PHP: date between date

I have two dates: 10-11-2010 and 17-11-2010 Now i would like to SELECT all rows with the dates between those two. How can I do that?

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL query String contains

I've been trying to figure out how I can make a query with MySQL that checks if the value (string $haystack ) in a certain column contains certain data (string $needle), like this: mysql_query(" SELECT * FROM `table` WHERE `column`.contains(…

Read More