Getting total days.

Teach

Hello.
We have a notice form which allows people to tell us if they're going to be for a long time, containing the start day/month/year and end day/month/year.

These are in the form of:

                <tr>
                  <th class="intro"><label>Start date:</label></th>
                  <td class="forminput"><select name="START-DAY">
                    <option value="" selected="selected">Day</option>
                    <option value="1st">1st</option>
                    <option value="2nd">2nd</option>
                    <option value="3rd">3rd</option>
                    <option value="4th">4th</option>
                    <option value="5th">5th</option>
                    <option value="6th">6th</option>
                    <option value="7th">7th</option>
                    <option value="8th">8th</option>
                    <option value="9th">9th</option>
                    <option value="10th">10th</option>
                    <option value="11th">11th</option>
                    <option value="12th">12th</option>
                    <option value="13th">13th</option>
                    <option value="14th">14th</option>
                    <option value="15th">15th</option>
                    <option value="16th">16th</option>
                    <option value="17th">17th</option>
                    <option value="18th">18th</option>
                    <option value="19th">19th</option>
                    <option value="20th">20th</option>
                    <option value="21st">21st</option>
                    <option value="22nd">22nd</option>
                    <option value="23rd">23rd</option>
                    <option value="24th">24th</option>
                    <option value="25th">25th</option>
                    <option value="26th">26th</option>
                    <option value="27th">27th</option>
                    <option value="28th">28th</option>
                    <option value="29th">29th</option>
                    <option value="30th">30th</option>
                    <option value="31st">31st</option>
                  </select>

              <select name="START-MONTH">
                <option value="" selected="selected">Month</option>
                <option value="January">January</option>
                <option value="February">February</option>
                <option value="March">March</option>
                <option value="April">April</option>
                <option value="May">May</option>
                <option value="June">June</option>
                <option value="July">July</option>
                <option value="August">August</option>
                <option value="September">September</option>
                <option value="October">October</option>
                <option value="November">November</option>
                <option value="December">December</option>
              </select>

              <select name="START-YEAR">
                <option value="" selected="selected">Year</option>
                <option value="<?php echo date('Y'); ?>"><?php echo date('Y'); ?></option>
                <option value="2007">2007</option>
              </select></td>
            </tr>

            <tr>
              <th class="intro"><label>End date:</label></th>
              <td class="forminput"><select name="END-DAY">
                <option value="" selected="selected">Day</option>
                <option value="1st">1st</option>
                <option value="2nd">2nd</option>
                <option value="3rd">3rd</option>
                <option value="4th">4th</option>
                <option value="5th">5th</option>
                <option value="6th">6th</option>
                <option value="7th">7th</option>
                <option value="8th">8th</option>
                <option value="9th">9th</option>
                <option value="10th">10th</option>
                <option value="11th">11th</option>
                <option value="12th">12th</option>
                <option value="13th">13th</option>
                <option value="14th">14th</option>
                <option value="15th">15th</option>
                <option value="16th">16th</option>
                <option value="17th">17th</option>
                <option value="18th">18th</option>
                <option value="19th">19th</option>
                <option value="20th">20th</option>
                <option value="21st">21st</option>
                <option value="22nd">22nd</option>
                <option value="23rd">23rd</option>
                <option value="24th">24th</option>
                <option value="25th">25th</option>
                <option value="26th">26th</option>
                <option value="27th">27th</option>
                <option value="28th">28th</option>
                <option value="29th">29th</option>
                <option value="30th">30th</option>
                <option value="31st">31st</option>
              </select>

              <select name="END-MONTH">
                <option value="" selected="selected">Month</option>
                <option value="January">January</option>
                <option value="February">February</option>
                <option value="March">March</option>
                <option value="April">April</option>
                <option value="May">May</option>
                <option value="June">June</option>
                <option value="July">July</option>
                <option value="August">August</option>
                <option value="September">September</option>
                <option value="October">October</option>
                <option value="November">November</option>
                <option value="December">December</option>
              </select>

              <select name="END-YEAR">
                <option value="" selected="selected">Year</option>
                <option value="<?php echo date('Y'); ?>"><?php echo date('Y'); ?></option>
                <option value="2007">2007</option>
              </select></td>
            </tr>

Our PHP mailer deals with this via:

$msg .= "Start date......... ".$_POST['START-DAY']." ".$_POST['START-MONTH']." ".$_POST['START-YEAR']."\n";
$msg .= "End date........... ".$_POST['END-DAY']." ".$_POST['END-MONTH']." ".$_POST['END-YEAR']."\n\n";

Basically, what we want it to achieve is to say in addition to the above:

Total vacation: XX days

How easy is that to accomplish?

Thanks. 🙂

bradgrafelman

Hmm. I would say convert each date into a Unix timestamp, such as with the [man]strtotime/man function. Now you have two integers that describe two dates in terms of the number of seconds after the Unix epoch each date is.

You can then subtract the two integers. Now you know how many seconds apart the two dates are. Divide by (606024) and round up... that's how many days apart the two dates are.

Teach

Hmm I don't really get it. :/

Installer

...convert each date into a Unix timestamp...

$start_uts = strtotime($_POST['START-DAY'] . $_POST['START-MONTH'] . $_POST['START-YEAR']);
$end_uts = strtotime($_POST['END-DAY'] . $_POST['END-MONTH'] . $_POST['END-YEAR']);

...subtract the two integers.

$total_secs = $end_uts - $start_uts;

Divide by (606024) and round up...

$days = $total_secs / (60 * 60 * 24);

bradgrafelman

EDIT: Nevermind...

Installer

Except that neither the month nor the day is an integer.

bradgrafelman

Oops, probably would have been a good idea to look at the HTML first :p

Teach

Thank you very much Installer. 🙂
Should that code you provided work okay? I didn't try it, because later I read that neither the month nor the day is an integer - does that code work with it how it is already?

Regards,

bradgrafelman

Yes, he was referring to the post I had made but then edited out after seeing his comment. His code was based off of my original idea, and it looks like it should work just fine.