如何通过PHP判断MySQL中的日期时间字段是否过去？ [关闭]

Question

I'm building a website for a school, with a place the teachers can add assignments. All these assignments are stored in a MySQL table, with a field of type datetime that stores the due date. I'm looking for a way, with PHP, to check if the due date is in the past so I can provide visual feedback for the teachers and students. Any help would be appreciated!

Answer 1

I would use PHP's date comparison tools. Here is an example:

$date1 = new DateTime("now");
$date2 = $yourDateFromTheDatabase;
if ($date2 < $date1) {
    //it still has time
} else {
    //time has passed
}

Does that help? You can find more examples here: http://php.net/manual/en/datetime.diff.php