how to compare hours and tell if the establishment is closed or open and return a Json message

Question

Help me... Thank you. This is the following I have an Api with Php + Sql and returns the data in Json. In my data you have two fields openRestaurante and closeRestaurante, opening hours of an establishment and closing time of the establishment how can I make this comparison of hours and return me only the open or closed message in my Json instead of returning me the registered hours?

Answer 1

You can perform date sum and subtraction operations using php’s Datetime and Dateinterval classes. http://php.net/manual/en/class.datetime.php http://php.net/manual/en/class.dateinterval.php

And then you can compare if the current time precedes the opening time or if it happens the closing time, thus indicating that the restaurant is closed.

I hope I’ve helped.

Answer 2

<?php
# dentro do seu while
$statusRestaurante = 'fechado';

# guarda o timestamp da hora que abre
$openTime  = new DateTime($result['openRestaurante']);
$openRestaurante = $openTime->getTimestamp();
# guarda o timestamp da hora que fecha
$closeTime = new DateTime($result['closeRestaurante']);
$closeRestaurante = $closeTime->getTimestamp();
# agora
$nowTime            =  new DateTime(date("H:i"));
$now = $nowTime->getTimestamp();
# se agora for maior ou igual a hora que abre e agora for menor ou igual a hora que fecha
if ( ($now >= $openRestaurante) && ($now <= $closeRestaurante) )
{
    $statusRestaurante = 'aberto';
}
# echo $statusRestaurante;
$out .= '"statusRestaurante": "'.$statusRestaurante.'",';