add days to date...

timandkitty

A user inputs a date into a textbox in this format:

2002-02-27

and clicks submit. It updates the database, and goes to a page with a textbox that has a date in the same format, only 14 days (2 weeks) earlier:

2002-02-13

This date can be changed if necessary at the user's discretion. Upon clicking submit, this too updates the database.

The trouble I am having is in creating that second date. Anybody got any helpful advice? (And please don't just say "read the manual"... I've been there and still can't figure out how to do what I want!)

Thank you sooooooo much!

DoD

I take it you want to create a date thats 2 weeks ago today?

well:

this is what you want:

http://www.php.net/manual/en/function.mktime.php

echo date ("Y-m-d" mktime(0,0,0,$month,$day,$year));

for the second, use

$day=$day-14;
echo date ("Y-m-d" mktime(0,0,0,$month,$day,$year));

Not sure about the date natations.

timandkitty

not necessarily today. in fact, never today. the first date will be at some point in the future. it will be entirely up to the user.

the second date then needs to subtract the day, like you have, but also configure itself if the first day happens to be the first of the month. the month would then change.

will the functions you wrote change the month and year appropriately if necessary, or just the day?

thanks...

timandkitty

i guess it does take the month and year into account.

cool!

now i just need to figure out how to separate the variables from one string into three variables...

shouldn't be a problem.

many many thanks!

DoD

Theres the explode function:

this will do it:

$date = "2002-02-27";
list($year,$month,$day) = explode("-",$data);

This will break it down by the - and then assign first the year, and so on.

Then put this through the script.

So what you want is:

list($year,$month,$day) = explode("-",$data);
$day=$day-14;
echo date ("Y-m-d" mktime(0,0,0,$month,$day,$year));

The best way for you to do your form, is to have 3 drop down boxes. One for month, date and year, so their put in the right order by the user. You will have to add the security to stop them having 31st Feb - as with mk time thats 3rd day in march. php.net link has an example of how to do this.