php - PHP和MYSQL中2个数据库表中的2次查询

Question

在PHP和MYSQL中查询2个数据库表中的2次

这是我的数据库

| time1   | time2 |
| 15:00   | 17:00 |

然后我想显示查询代码中两个数据库表之间是否已经有时间

例如

 $a = '14:00';
 $b = '16:00';
if($a <= $time1 && $b >=$time2){
   echo 'it already has a time in the database';

 }else{
 echo 'dont have time in the database';
  }

 output will be
  it already has a time in the database

提前致谢我想要查询该样本。再次感谢

Answer 1

WHERE '$a' >= time2 OR '$b' <= time1