Inserting date based on insert values

BEFOR

I'm inserting into a col 'EndRun' with format of 0000-00-00 on a single insert form. This shows an expiration date.

'StartRun' is entered manually from textfield, any future date and it's being inserted as it should

'Runtime' is from drop menu and is numeric representing days
(ex: 30) This is added to 'StartRun' to get the 'EndRun' value.

Problem is the code wants to add to years, and not days as it should. For example:

30 //Runtime
2004-07-11 //StartRun
2034-07-09 // inserts incorrectly for End Run

date('Y-m-d',(mktime(0,0,0,substr($HTTP_POST_VARS['StartRun'],5,2),substr($HTTP_POST_VARS['StartRun'],8,2), substr($HTTP_POST_VARS['StartRun'],0,4)) + mktime(0,0,0,0,$HTTP_POST_VARS['Runtime'],0)))

What is wrong here?

devinemke

as with nearly every problem posting here involving dates: use timestamps

$StartRun = '2004-06-17';
$Runtime = 30;

$StartRun_timestamp = strtotime($StartRun);
$EndRun = $StartRun_timestamp + ($Runtime * 24 * 60 * 60);
echo $StartRun . ' plus ' . $Runtime . ' days is ' . date ('Y-m-d', $EndRun);

khjart

You could also go by this

$startrun = strtotime("2004-07-11");
$runtime = 30;
$endrun = date("Y-m-d", strtotime("+$runtime day", $startrun));

BEFOR

Appreciate the help, but I think I really need to keep in the format it's in.

I just cannot figure out why it is adding to years and how to get to add to days.

devinemke

...but I think I really need to keep in the format it's in

both my example and khjart's do keep the date in the format it was in (YYYY-MM-DD)

BEFOR

How can I use these with StartRun and Runtime as $HTTP_POST_VARS off the same page? -They haven not been declared until user does so.

On reason I've been trying to keep away from timestamp is mysql's tendency to change these values when table is reaccesed and they occur first in table (not actually on this page but on another update page it will be).

devinemke

simply extract the values from the POST array:

$StartRun = $HTTP_POST_VARS['StartRun'];
$Runtime = $HTTP_POST_VARS['Runtime'];

$StartRun_timestamp = strtotime($StartRun); 
$EndRun = $StartRun_timestamp + ($Runtime * 24 * 60 * 60); 
echo $StartRun . ' plus ' . $Runtime . ' days is ' . date ('Y-m-d', $EndRun);

BEFOR

Can I put this within hidden input ?:

<input type="hidden" name="EndRun" value="<? $StartRun = $HTTP_POST_VARS['StartRun']; 
$Runtime = $HTTP_POST_VARS['Runtime']; 
$StartRun_timestamp = strtotime($StartRun);  

$EndRun = $StartRun_timestamp + ($Runtime * 24 * 60 * 60);
echo $StartRun . ' plus ' . $Runtime . ' days is ' . date ('Y-m-d', $EndRun);
?>">

devinemke

Can I put this within hidden input

let's back up here. you are collecting user input on a form with the StartRun and Runtime. once the user submits the form you can then calculate the EndRun based on that user input. you can't put the EndRun in a hidden form field because it doesn't exist yet (not until the form is submitted). if you are doing a multi-part from you ceratinly pass the EndRun on to the next step in a hidden variable

echo '<input type="hidden" name="EndRun" value="' . $EndRun . '">';