php - 如何获取所选年份的所有日期？

Question

我的代码功能是获取所选年份范围内季节从/到的所有值。

我有 2 个下拉列表供用户选择年份/年份的季节。但我有一个错误，如果巡回赛的两个季节都比所选年份小/大，我就无法获得值(value)。示例:

所选季节自/至:2015 -2016

from          to
2011-05-06    2014-11-12 (not get - work)
2012-04-01    2015-12-31 (get - work)
2015-01-01    2016-08-10 (get - work)
2016-08-11    2018-12-28 (get - work)
2017-01-01    2018-01-01 (not get - work)

2014-01-11    2017-01-01 (I want get this too, because my selected year is 2015-2016)

我的代码:

$first_day = mktime(0, 0, 0, 1, 1, $params['seasonfrom']) ; //2015-01-01
$first_day = "'".date('Y-m-d',$first_day)."'";

$last_day = mktime(0, 0, 0, 12, 31, $params['seasonto']) ;  //2016-12-31
$last_day = "'".date('Y-m-d',$last_day)."'";

$str1.="(ts.SsnFrom >= {$first_day} AND ts.SsnFrom <={$last_day} 
OR ts.SsnTo >= {$first_day} AND ts.SsnTo <={$last_day})";

谁能给我一个解决方案。谢谢!!

Answer 1

我不懂 PHP。一般都建议这样。这可能对您有帮助。

$str1.="({$first_day} BETWEEN ts.SsnFrom AND ts.SsnTo OR {$last_day} BETWEEN ts.SsnFrom AND ts.SsnTo)";