Page 1 of 1

PHP time (deadline within one week)

Posted: Mon Dec 21, 2009 6:55 am
by koolsamule
Hi Chaps,

I have a column ['projdue'], which stores the deadline for a project.
I have PHP code and <span class>'s to show projects that are within timescale, due today and overdue:

Code: Select all

<?php 
      // get the date parts from the MySQL date
      $dateparts = preg_split('/[-\s]/', $row_rsProjects['projdue']);
      // get the Unix timestamp for midnight at the beginning of the due date
      $projdue = mktime(0,0,0, $dateparts[1], $dateparts[2], $dateparts[0]);
      // get the Unix timestamp for midnight at the beginning of today
      $today = mktime(0,0,0, date('n'), date('j'), date('Y'));
      if ($today == $projdue) { ?>
      <tr class="duetoday">
        <?php } else if ($today > $projdue) { ?>
        <tr class="within">
          <?php } else if ($today < $projdue) { ?>
        <tr class="overdue">
          <?php }?>
What I'm after is a bit of code to flag-up any projects that are due in 7 days

Re: PHP time (deadline within one week)

Posted: Mon Dec 21, 2009 7:13 am
by koolsamule