如何检查当前日期是否在假期日期范围内?我有一个表"holidays",有两个DATE列,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";
}
?>
你不需要有一个循环,所以你可以像这个一样做
<?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);
}
?>
试试这个。
<?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));
}
}
?>
这应该有效:
<?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']));
}
$resu
将包含结果行数。因此,您必须验证$resu == 0
是否