add one year to datetime with php

Question

$data['user']['time'] = '2011-03-07 00:33:45';    

how can we add 1 year to this date ?

something like $newdata = $data['user']['time'] + 1 year ?

or

$newdata = 2012-03-07 00:33:45

Thanks

Adam Ramadhan

Answer 1

strtotime() is the function you're looking for:

$data['user']['seal_data'] = date('Y-m-d H:i:s', strtotime('+1 year', strtotime($data['user']['time'])));

Answer 2

First, you have to convert the MySQL datetime to something that PHP can understand. There are two ways of doing this...

1. Use UNIX_TIMESTAMP() in your query to tell MySQL to return a UNIX timestamp of the datetime column.

   SELECT whatever, UNIX_TIMESTAMP(myTime) AS 'myUnixTime' FROM myTable;
   

2. Use DateTime::createFromFormat to convert your string time to something PHP can understand.

   $date = DateTime::createFromFormat('Y-m-d H:i:s', $data['user']['time']);
   

---

Once that is done, you can work with the time... Depending on the method you used above, you can use one of the following.

1. If you have a unix timestamp, you can use the following to add a year:

   $inAYear = strtotime('+1 year', $data['user']['unixTime']);
   

2. If you have a DateTime object, you can use the following:

   $inAYear = $date->add(new DateInterval('P1Y'));
   

---

Now, to display your date in a format that is respectable, you must tell PHP to return a string in the proper format.

1. If you have a unix timestamp, you can use the following:

   $strTime = date('Y-m-d H:i:s', $inAYear);
   

2. If you have a DateTime object, you can use the following:

   $strTime = $inAYear->format('Y-m-d H:i:s');
   

---

Alternatively, if you don't want to deal with all of that, you can simply add one year when you query.

SELECT whatever, DATE_ADD(myTime, INTERVAL 1 YEAR) AS 'inAYear' FROM myTable;