在php中比较从mysql到time（）的时间

Question

i need help for this. here's the scenario the link is available in 7:00AM to 7:30AM which that time are from mysql database.

StartTime = 2014-03-19 07:00:00

EndTime = 2014-03-20 07:30:00

iv'e tried converting it to strtotime() in php.

so here's my code

$date_s = new DateTime($row->StartDate);

$date_e = new DateTime($row->EndDate);

$g = date("Y-m-d H:i:s");

<?= strtotime($date_s->format('Y-m-d H:i:s')) > strtotime($g) && strtotime($date_e->format('Y-m-d H:i:s')) < strtotime($g) ? "true" : "false"; ?>

the result always fail me, im stack about 1 hour ago. can anyone help please. :D

Answer 1

You could compare DateTime object directly:

$date_s = new DateTime($row->StartDate);
$date_e = new DateTime($row->EndDate);
$now = new DateTime();

if ($now > $date_s && $now < $date_e) {

}

Or not using DateTime object:

$date_s = strtotime($row->StartDate);
$date_e = strtotime($row->EndDate);
$now = time();

if ($now > $date_s && $now < $date_e) {

}

Using either one but not BOTH.