How to add date?

[edpudol]

How could I add date, for example $currentdate + 2, the result should be September 1, 2004 if currentdate is August 30, 2004.

Thanks

[LordShryku]

[man]date[/man] and [man]strtotime[/man].

echo date("m/d/Y", strtotime("+2 days"));

[edpudol]

thanks... 🙂

[edpudol]

Still have trouble with the date why does this code

$dateend =date($postdate, strtotime("+$n days"));

return this result : 2009-04-20

and this code

$cdate=date("m/d/y");

return this result: 2009-01-04

What is wrong with my code?

Thanks

[LordShryku]

$cdate=date("m/d/y");
return this result: 2009-01-04

Eh? That's a completely different format...

[edpudol]

How could I fix this problem? Could you please help me if you have an idea. thanks

[edpudol]

Hello!

I try it again it work, but when I save it to my mySQL table with DATE datatype and when I try to view the save record I got the prevous problem (2009-01-04 )

[Weedpacket]

Which format are you using? m/d/y or Y-m-d?

[xblue]

if it is meant to go into a mysql db anyway, you might consider using mysql functions instead of php, like

NOW() + INTERVAL 2 DAY (for datetime columns)
or
CURDATE( ) + INTERVAL 2 DAY (for date columns)

[edpudol]

I Use this code when I save the date to my mySQL table:

$cdate=date("m/d/y");
$dateend = date("m/d/Y", strtotime("+3 days"));
//save record into table
mysql_query("INSERT INTO Mtable
VALUES ('$cdate',
'$dateend')") or die(mysql_error());

The above code works, but when I retrieve it and try to view the result using the following code:

echo $myrow[dateend];
echo $myrow[datepost];

I got this results :
for dateend 2009-04-20
and for datepost 2009-01-04

I tried to use this code:

echo date ("F j, Y",$myrow[dateend]);
echo date("F j, Y",$myrow[datepost]);

but I get the following result for both code:

December 31, 1969

Need your help, thank you in advance

[drawmack]

mysql stores dates like this yyyy-mm-dd this is done to make date comparisons easier and quicker programatically because you have no special case accounting when you store dates this way because

2005-01-01 is bigger then 2004-12-31

timestamps in mysql are stored as yyyymmddhhmmss for the same reason as above. Just use the mysql date functionts to format them before giving them to php and all will be right in the world.

[edpudol]

I am totally newbie in PHP so I don't really understand whay you mean.

Could you please give me a sample code that I may edit like what you have done to other member of this forum.

A sample code how can I save those dates and a sample code for view them.

Thanks for the time

[Weedpacket]

Change your "m/d/y" into "Y-m-d".

[edpudol]

Thanks Weedpacket, now it's working, How can I format this out : 2004-9-04 into September 4, 2004.

Thanks

[Weedpacket]

Originally posted by edpudol
Thanks Weedpacket, now it's working, How can I format this out : 2004-9-04 into September 4, 2004.

Use [man]date[/man] and [man]strtotime[/man]

Woah, déjà vu.