PHP time (deadline within one week)

Discussion in 'PHP' started by koolsamule, Dec 21, 2009.

0
  1. #1
    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:
    
<?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 }?>
    PHP:
    What I'm after is a bit of code to flag-up any projects that are due in 7 days
     
    koolsamule, Dec 21, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    why do you need to do calculation at php ? You can do it at mysql level also making it more simpler.
     
    mastermunj, Dec 21, 2009 IP
  3. koolsamule

    koolsamule Peon

    Messages:
    101
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    koolsamule, Dec 21, 2009 IP