javascript - 如何将今天的日期和时间与数据库中的字符串进行比较？

Question

这是我的 table :

|    date    | open  | close |
-----------------------------
| 2016-08-05 | 04:00 | 05:00 |
| 2016-05-05 | 05:00 | 06:00 |
| 2016-09-05 | 06:00 | 07:00 |

我需要做出以下声明:

if ($todaydate == date && open <= $todaytime <=close) {
      // go to some link
}else{
     // failed alert
}

如何获取 $todaydate 和 $todaytime？

Answer 1

您可以完全用 SQL 来完成此操作:

SELECT NOW() BETWEEN CONCAT(date, ' ', open, ':00') AND CONCAT(date, ' ', close, ':00') AS `store_is_open`
FROM `my_table`

在 JavaScript 中:

var openDate = new Date(date + ' ' + open).getTime();
var closeDate = new Date(date + ' ' + close).getTime();
var now = new Date().getTime();

console.log(openDate <= now && now <= closeDate);