How to compare two dates from MYSQL in php?
In this tutorial, we will explain to you how you can compare two dates from MYSQL in PHP.
1. Code:
<?php function compareTwoMysqlDate($date1, $date2){ $d1 = new DateTime($date1); $d2 = new DateTime($date2); if ($d1 == $d2) { return 0; } if ($d1 > $d2) { return 1; } return -1; } $str = compareTwoMysqlDate("2018-11-15 00:00:00", "2018-11-11 00:00:00"); echo($str); ?>
2. Example:
Input:
"2018-11-15 00:00:00", "2018-11-11 00:00:00"
Output:
1