如何比较日期和显示记录，只有它在今天和到期之前

Question

I want to display database records only if testfrom date is todays and testto date is not over.

The following code I tried below does not seem to be working well, could someone have a look what am I doing wrong?

the stored date value in the database is

testfrom - 2017-02-23 00:00:00
testto - 2017-02-24 23:59:59

my code

    $dt = date("Y-m-d");
    $srt = date("Y-m-d", strtotime($r['testfrom']));
    $end = date("Y-m-d", strtotime($r['testto']));
 if($srt >= $dt || $end <= $dt){

    }

is this the right way?

Appreciate your valuable time

Answer 1

change your condition like this:

 $dt = date("Y-m-d");
    $srt = date("Y-m-d", strtotime("2017-02-23 00:00:00"));
    $end = date("Y-m-d", strtotime("2017-02-24 23:59:59"));
 if($srt == $dt && $end >= $dt){
  echo "yes";
    }