需要检查日期时间并在我的div中添加一个类

Question

 foreach($this->connection->query($sql) as $row) {

                     $class = "";
                     if($row['datum'] > date("Y-m-d") && $row['tijd'] > date("H:i:s")) { $class = "toekomst"; }
                     if($row['datum'] == date("Y-m-d") && $row['tijd'] == date("H:i:s")) { $class = "vandaag"; }
                     if($row['datum'] < date("Y-m-d") && $row['tijd'] < date("H:i:s")) { $class = "verleden"; }

                     var_dump($class);
                     $output .= "<tr class='$class'>";
                          $output .= "<td>";
                               //Rotate date from sql to dutch notation
                               $datum   = $row['datum'];
                               $dag     = substr($datum, 8, 2);
                               $maand   = substr($datum, 5, 2);
                               $jaar    = substr($datum, 0, 4);
                               $datum   = $dag . "-" . $maand . "-" . $jaar;

                               $output .= $datum;

i think i almost got it but still not working perfect if i dump the class its giving me

string(0) "" string(8) "verleden" string(0) "" string(0) "" string(0) "" string(0) "" string(0) "" string(0) "" string(0) "" string(0) "" string(8) "verleden" string(0) "" string(0) "" string(8) "toekomst" string(8) "toekomst"

Answer 1

Create two DateTime objects, and compare them in your conditions. DateTime objects can be compared to see which is the biggest (in date-time).

Preferably you would have one column date instead of separated into two different columns.

$now = new DateTime();
$date = new DateTime($row['datum']." ".$row['tijd']);

if ($now > $date) {
    $class = 'toekomst';
} elseif ($now == $date) {
    $class = 'vandaag';
} elseif ($now < $date) {
    $class = 'verleden';
}