php if statement to check if current datetime is between 2 datetime columns

Question

PostQopen and PostQClose are datetime columns. I need a php if statement to check if the current datetime is between the PostQopen and PostQClose columns.

$now = date('Y-m-d H:i:s');

if($rows['PostQopen'] >= '$now' && $rows['PostQClose'] < '$now' ){

echo "TRUE";

} else { 

echo "FALSE";

};

Answer 1

Use DateTime.

$now = new DateTime("now");
$PostQopen = new DateTime($rows['PostQopen']);
$PostQClose = new DateTime($rows['PostQClose']);

if($PostQopen >= $now && $PostQClose <=$now){
 // do ur stuff
}