检查当前日期是否在假日日期范围内
检查当前日期是否在假日日期范围内
提问于 2012-08-30 18:35:06
如何检查当前日期是否在假日日期范围内？我有一个表"holidays“，它有两个日期列: start_date和end_date。用户可以在该范围内定义假日日期。我需要做一个循环来检查假日日期范围内的当前日期，如果是，则当前日期变为"+1天“，然后再次检查。到目前为止我已经做到了：
<?php
include ("config.php");
$curdate = date('Y-m-d', time());
$res = mysql_query("SELECT * FROM holidays WHERE '$curdate' BETWEEN `start_date` and `end_date`");
$resu = mysql_num_rows($res);
if ($resu == NULL)
{
echo "Date is not range";
}
else
{
echo "Date is in range";
}
?>回答 4
Stack Overflow用户
回答已采纳
发布于 2012-08-30 18:53:51
你不需要有一个循环，所以你可以这样做
<?php
include ("config.php");
$curdate = date('Y-m-d', time());
$res = mysql_query("SELECT id FROM holidays WHERE '$curdate' BETWEEN `start_date` and `end_date`");
$resu = mysql_num_rows($res);
if ($resu == 0)
{
echo "Date is not range";
}
else
{
$res = mysql_query("SELECT end_date FROM holidays WHERE end_date > '$curdate' ORDER BY end_date ASC LIMIT 1");
$resu = mysql_fetch_array($res);
$next_day = strtotime($resu['end_date']) + 24 * 60 * 60;
echo 'The next available day is ' . date("Y-m-d", $next_day);
}
?>Stack Overflow用户
发布于 2012-08-30 18:49:23
试试这个吧。
<?php
include ("config.php");
$curdate = date('Y-m-d', time());
while(1) {
$res = mysql_query("SELECT * FROM holidays WHERE '$curdate' BETWEEN `start_date` and `end_date`");
if(!mysql_num_rows($res))
{
echo "Date is not range";
break;
}
else
{
echo "Date is in range";
$TS = strtotime($curdate);
$curdate = date('Y-m-d', strtotime('+1 day', $TS));
}
}
?>Stack Overflow用户
发布于 2012-08-30 18:49:26
这应该是可行的：
<?php
include ("config.php");
$curdate = date('Y-m-d', time());
while(1)
{
$res = mysql_query("SELECT * FROM holidays WHERE '$curdate' BETWEEN `start_date` and `end_date` LIMIT 1");
if( !mysql_num_rows($res) )
{
echo 'closest data available: ' . $curdate;
break;
}
$ar = mysql_fetch_assoc($res);
$curdate = date('Y-m-d', strtotime("+1 day", $ar['end_date']));
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/12194934
复制相关文章
相似问题
腾讯云开发者
