Add 1 Year to current date ?

[Syl]

I've been through the php.net docs, and this newsgroup - and all seems
to be configured properly, but this statement is still not working:

switch ($level) {
case 1:
$nextyear = mktime(0,0,0,da te("Y")+1,date( "m"),date("d")) ;
$nextyear = strftime("%Y%m% d",$nextyear );
break;

< snip case >

$query = "INSERT INTO users VALUES (NULL, '$username',
password('$user password'), $level, '$fname', '$lname', '$tel',
'$email', '$addr', '$city', '$prov', '$country', '$pcode', 'comm',
'$today', '$nextyear')";

Any ideas ? It's a date field in the table - it displays:
YYYY-MM-DD --> 2005-09-22

Thanks!

[iuz]

Syl wrote:

I've been through the php.net docs, and this newsgroup - and all seems
to be configured properly, but this statement is still not working:

switch ($level) {
case 1:
$nextyear = mktime(0,0,0,da te("Y")+1,date( "m"),date("d")) ;
$nextyear = strftime("%Y%m% d",$nextyear );
break;
date('Y-m-d', 31536000) // this return the next year string (60*60*24*365)
< snip case >

$query = "INSERT INTO users VALUES (NULL, '$username',
password('$user password'), $level, '$fname', '$lname', '$tel',
'$email', '$addr', '$city', '$prov', '$country', '$pcode', 'comm',
'$today', '$nextyear')";

Any ideas ? It's a date field in the table - it displays:
YYYY-MM-DD --> 2005-09-22

Thanks!
by the way in sql is probably better something like.. '$today', date_add(now(), INTERVAL 1 year ))";

leaving the responsability of the year add directly to the dbms..

--
www.iuz-lab.info

[Gordon Burditt]

>I've been through the php.net docs, and this newsgroup - and all seems

to be configured properly, but this statement is still not working:

switch ($level) {
case 1:
$nextyear = mktime(0,0,0,da te("Y")+1,date( "m"),date("d")) ;
$nextyear = strftime("%Y%m% d",$nextyear );
break;

< snip case >

$query = "INSERT INTO users VALUES (NULL, '$username',
password('$use rpassword'), $level, '$fname', '$lname', '$tel',
'$email', '$addr', '$city', '$prov', '$country', '$pcode', 'comm',
'$today', '$nextyear')";

Any ideas ? It's a date field in the table - it displays:
YYYY-MM-DD --> 2005-09-22

I would replace '$nextyear' in the MySQL query with:
adddate(now(), INTERVAL 1 YEAR)

Gordon L. Burditt

[Justin Koivisto]

iuz wrote:

Syl wrote:

I've been through the php.net docs, and this newsgroup - and all seems
to be configured properly, but this statement is still not working:

switch ($level) {
case 1:
$nextyear = mktime(0,0,0,da te("Y")+1,date( "m"),date("d")) ;
$nextyear = strftime("%Y%m% d",$nextyear );
break;

date('Y-m-d', 31536000) // this return the next year string (60*60*24*365)

What about on a leap year? ;) I tend to use strtotime for this kind of
thing since it is much easier to read some time down the road:

date('Y-m-d',strtotime('+ 1 year'));

--
Justin Koivisto, ZCE - ju****@koivi.co m
http://koivi.com

[Chung Leong]

If you want to add a year to the current date, then add one to the
year. 2005 + 1 = 2006. It's not rocket science.

Example:

extract(getdate );
$year = $year + 1;
echo "$year-$month-$mday";

[Syl]

Thanks iUz - I'll give it a go.

I agree re: letting the sql dfo the work, BUT - there are two cases to
resolve boefore the Insert akes place.

has the registered user signed up for one *month* subscription or one
*year* subscription.

That's why I have the case statement.

Thanks agaion to all who replied.

[Syl]

Awesome.

So - I kept the case statement, but just made two variables to dump
into the insert statement.

Thanks again!