PHP DateTime, paid date + a year term

Question

Possible Duplicate:
add one year to datetime with php

Paid Date: 2012-10-19 13:13:20

Term: 3 (three years)

I need to turn these two values into a DateTime that I can then compare to todays date and find out if the subscription is coming up for renewal.

Not sure how to properly accomplish this...

I've tried:

$term = $row['term'];   
$paid = $row['paid_date'];

$renew = strtotime("+$term years", $paid);
$today = strtotime('now');

But apparently in this situation, all dates are less than ...

Whoever voted this down is a complete waste of breath. Thanks for helping out ... — dcolumbus, Oct 31 '12 at 21:18
I find it funny that your first try was multiplying by `$term` (I didn't downvote you) — Alexander, Oct 31 '12 at 21:18
Yeah, it's hilarious. I didn't actually attempt that ... it's just an example of what I need to accomplish — dcolumbus, Oct 31 '12 at 21:19
http://stackoverflow.com/questions/5212240/add-one-year-to-datetime-with-php answer 2, -1 for not even attempting to google — Steve's a D, Oct 31 '12 at 21:24
Steve ... I'm looking through PHP.net right now and there are so many different ways of potentially doing this. And that's not the result I need. — dcolumbus, Oct 31 '12 at 21:26
@dcolumbus Given that there's no actual question, this is perfectly worth a downvote. — Philip Whitehouse, Oct 31 '12 at 21:36

score 0 · Answer 1 · answered Oct 31 '12 at 21:30

0

turn the date into a timestamp and compare it with todays timestamp; if the difference is more than 3 years in seconds the subscription is running out.

answered Oct 31 '12 at 21:30

clem

3,345
1
22
33

SteB · Answer 2 · 2012-10-31T22:32:43.587

Convert paid + 3 years and today into unix timestmps, if the renewal date is less than today, the subscription has expired.

$renew = strtotime('+'. $term .' years', $paid);
$today = strtotime('now');

If ($renew < $today) 
{
  //subscription has run out
}

Assumes $term is an integer from a database and $paid is a datetime from a MySQL database converted to a unix timestamp (select unix_timestamp(paid) as paid from paidtable).

score 0 · Accepted Answer · answered Oct 31 '12 at 21:37

0

If you have the paid date as a string:

if(strtotime("2012-10-19 13:13:20 +3 years") > time()) {
     // expired
}

If you have paid date as a timestamp:

if(strtotime("+3 years", $paidDate) > time()) {
     // expired
}

answered Oct 31 '12 at 21:37

Salman A

262,204
82
430
521

1

Assume that paid_date is MySQL datetime and term is integer, it is sufficient to use `strtotime("{$row['paid_date']} +{$row['term']} years")`. – Salman A Oct 31 '12 at 21:58
That did it. Thanks for helping me out, Salman. – dcolumbus Oct 31 '12 at 22:01

PHP DateTime, paid date + a year term

3 Answers3