Add +1 year with data already saved using php

Question

i have db with date format like this : 28 - 04 - 2015

how to add that data +1 year with php?

any idea?

Thanks very much!

http://stackoverflow.com/questions/18269556/php-date-add-1-year-to-current-date — Jose Manuel Abarca Rodríguez, Apr 28 '16 at 17:31
Your date seems to have blank spaces on the left and right of the hyphens. — Jose Manuel Abarca Rodríguez, Apr 28 '16 at 17:42

Andreas · Accepted Answer · 2016-04-28T17:44:51.960

0

echo date('d - m - Y', strtotime('+1 years', strtotime(str_replace(" ", "",$DateFromDB))));

EDIT: Sorry wrong format

Working example:
http://sandbox.onlinephpfunctions.com/code/148e670733af48fdde6fc37884550744defb6eca

edited Apr 28 '16 at 17:44

answered Apr 28 '16 at 17:32

Andreas

23,610
6
30
62

how to add +1 year using my data? Eg. : `28 - 04 - 2015` using php and be `28 - 04 - 2016` is it possible? – Japar S Apr 28 '16 at 17:34
@Andreas, imagine the date is stored in a variable, how would you include the variable in your answser? – Jose Manuel Abarca Rodríguez Apr 28 '16 at 17:35
Sorry forgot that.. :) just a sec – Andreas Apr 28 '16 at 17:36
@JaparS , Jose , Updated – Andreas Apr 28 '16 at 17:38
1

Missing the last parenthesis! – Jose Manuel Abarca Rodríguez Apr 28 '16 at 17:38
not work...i already try :( – Japar S Apr 28 '16 at 17:41
@JaparS, it works, maybe because of the spaces in your date. – Jose Manuel Abarca Rodríguez Apr 28 '16 at 17:44
1

@JoseManuelAbarcaRodríguez correct with str_replace(" ", "",$date) it works – Andreas Apr 28 '16 at 17:45
1

Working! Many thanks! – Japar S Apr 28 '16 at 17:47
@JaparS No problem! It was tougher than at firts glance. Just accept the answer and I'm happy :-) – Andreas Apr 28 '16 at 17:48
@JaparS Ok you were qicker than me – Andreas Apr 28 '16 at 17:48

score 0 · Answer 2 · edited Apr 28 '16 at 21:04

0

date('d - m - Y', strtotime($date . ' +1 years'));

edited Apr 28 '16 at 21:04

Matt S

14,976
6
57
76

answered Apr 28 '16 at 17:35

T.J. Compton

405
2
11

There is a period after `$date`. – Jose Manuel Abarca Rodríguez Apr 28 '16 at 17:43

score 0 · Answer 3 · answered Apr 28 '16 at 17:39

0

You can update database using INTERVAL

UPDATE table SET date = DATE_ADD(date, INTERVAL 1 YEAR)

answered Apr 28 '16 at 17:39

abhayendra

197
6

score 0 · Answer 4 · answered Apr 28 '16 at 17:46

Let's say you save the value of your date in the variable named $date:

$date = '28 - 04 - 2015';
$date = strtotime(str_replace(' ', '', $date)); // Remove the spaces from your date and convert it into a time
$date = strtotime('+1 years', $date); // Add one year to the result
echo date('m - d - Y', $date); // Print the date 1 year later in the same format you had originally

The result would be:

28 - 04 - 2016

If you want it in one line:

$date = strtotime('+1 years', strtotime(str_replace(' ', '', $date)));

Add +1 year with data already saved using php

4 Answers4