auto date and display date 30 days after

a720

I know how to get the auto date function working in mysql. What I want to be able to do is add 30 days to the date using another field called expiredate and be able to output this to the the php page.

I was wondering how I would go and write my php code for this.

maybe
<? expiredate = $date + 30 ?>
<p>Pat message expires on <? echo "$expiredate"; ?>

I think you get the idea.

hand

SELECT DATE_ADD(now(), INTERVAL 30 DAY) AS expiredate;

http://www.mysql.com/doc/en/Date_and_time_functions.html

a720

Thank you very much for your help. I should be able to work this out.

Graffiti

How would that work with PHP

$heute=date("Y-m-d");
$vorher = $heute-14days;

Regards
Volker

Graffiti

Got it.

Since mktime() returns a unixtimestamp (seconds from 1.1.1970) it is easy to e.g. substract two weeks (which would be 1209600 seconds).

Then reformat, and voila.

Volker

TodManPlaa

hi,
another suggestion re how to do it in PHP.

I use this to turn over issues at midnight Thai time - so am counting the days rather than hours, but the principle is the same.

/*get the time*/

$today=date("Y-m-d");

/*deal with the time difference (the servers are in the US, but the users are in Thailand)*/

$offset="11";/*meaning 11 hours ahead of the timezone where the servers live*/

$adjust = ($offset * 60 * 60);/*turn the offset into seconds*/

$today=date("Y-m-d",time()+$adjust);

The above could be condensed if you wanted

so many different ways to do things in PHP - its great!