PHP Date_Add()

[smti]

Hi,

 

I am currently working on a script where I have to determine the current date and then add five days to the current date. I have tried using the experimental Date_Add function, but have not had any luck making it work. Does anyone have any idea how I can achieve my goal? I need to add five days to the current date and then use the outputted date in a MYSQL query. Here is what I have thus far:

 

$currentdate=date("m.d.Y");

 

Thank You,

 

smti

 

[ionik]

$date = time();
$newDate = $date + (86400 * 5);

 

New date is the current date + 5 days

 

Have fun

 

O letme explain for you

Simply retrieve the current timestamp using time(), 86400 is the numerical value for the number of seconds in a day, add that to the current timestamp multiplied by and you now have a timestamp advanced 5 days  

1 = Second, 60 = Minute,3600 = Hour, 86400 = day

(1*60*60*24)

 

[gffg4574fghsDSGDGKJYM]

You can do that in pure SQL like that :

 

SELECT DATE_ADD(CURRENT_DATE(), INTERVAL 5 DAY);

 

As far i know date_add() isn't experimental at all :

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add