PHP从现在到日期之间的天数

克雷格·拉弗蒂(Craig Lafferty)

我通过邮寄将预订信息从php发送到javascript。使用floor($eventTime/(60*60*24)) - floor(time()/(60*60*24));我告诉我的javascript代码,根据事件的日期将事件放置在何处。$eventTime是Unix时间戳。例如,在21号的任何日期都应该放在第一个方框中,在22号的任何一天都应该放在方框2中,依此类推。我在做什么错了?以小时为单位的时间会影响显示预订的日期,在19日和20日发生的事件混合在一起,等等,但是我将发言时间设置为天数,所以我不明白。明确地说,我想要从现在到另一个日期的天数,但不包括或不考虑小时/分钟。因此,如果今天是10日,那么10日的任何保留,无论在什么时间(00:00:00-23:59:59)都应将其“ timeFrom”变量表示为0。发生的事情是10日和11日的日期在此示例中,当第10位应为0且第11位应为1时,都将0发送为“ days between”变量。

这是相关的PHP

while ($appResult = $stmt->fetch(PDO::FETCH_ASSOC))
{
    $tz = new DateTimeZone('America/Chicago'); // maybe this comes from the client side
    $now = new DateTime('now', $tz);
    $eventTime = new DateTime($appResult["time"], $tz);
    $now->setTime(0, 0);
    $eventTime->setTime(0, 0);
    $diff = $now->diff($eventTime);
    $days = $diff->d;
    $postString .= $days;
    $postString .= ".";
    $postString .= $appResult['id'];
    $postString .= ".";
    $postString .= date("H.i",strtotime($appResult['time']));
    $postString .= ".";
    $postString .= $appResult['members'];
    $postString .= ".";
    $postString .= $appResult['admin'];
    $postString .= ".";
    $postString .= $appResult['message'];
    $postString .= ".";
    $postString .= $appResult['tools'];
    $postString .= ".";
    $postString .= $appResult['location'];
    $postString .= ".";
    $postString .= $appResult['time'];
    $postString .= ".";
    $postString .= $appResult['userCount'];
    $postString .= ".";
    $postString .= $appResult['class'];
    $postString .= "!";
}

和相关的jQuery

function(data)
{
    $(".eventContainers > div:not(.eventHeaders) ").children().remove();
    var dateDays = data.split("@")[0].split(",");
    var appointments = data.split("@")[1].split("!")
    var resultsContainer = $(".eventHeaders");
    for(var i = 0; i < 5; i++)
    {
       $(resultsContainer[i]).find(".eventDay").text(dateDays[i].split(".")[0]);
       $(resultsContainer[i]).find(".eventWeek").text(dateDays[i].split(".")[1]);
    }
    for(var i = 0; i < $(appointments).size() - 1; i++)
    {
       var inEvent = false;
       for(var j = 0; j < $(appointments[i].split(".")[4].split(",")).size(); j++)
       {
        if(appointments[i].split(".")[4].split(",")[j] == id)
        inEvent = true;
       }
       var appendString = "";
       var parentStyle;
       var buttonStyle;
       var clicked;
       var style = ['style="background-image:url(\'appAdd.png\')"','style="background-color:rgba(0,0,0,0.15)"','style="background-image:\\\'\\\'"','style="background-color:rgba(0,0,0,0.3)"'];
       if(inEvent)
       {
          clicked = "true";
          parentStyle = style[1];
          buttonStyle = style[0];
       }
       else
       {
          clicked = "false";
          parentStyle = style[3];
          buttonStyle = style[2];
       }
       appendString += "<div id='" + appointments[i].split(".")[1] + "' class='appointmentIndivContainer' " + parentStyle + "><div class='appointmentJoinButton' " + buttonStyle + "></div><p class='appointmentTime'>" + getTime(appointments[i].split(".")[2], appointments[i].split(".")[3]) + "</p><p class='appointmentLocation'>" + appointments[i].split(".")[8].replace(/\+/g, ' ') + "</p>   <p class='dataContainers admin'>" + appointments[i].split(".")[5] + "</p>      <p class='dataContainers message'>" + appointments[i].split(".")[6].replace(/\+/g, ' ') + "</p>    <p class='dataContainers tools'>" + appointments[i].split(".")[7].replace(/\+/g, ' ') + "</p>     <p class='dataContainers userCount'>" + appointments[i].split(".")[9] + "</p><p class='dataContainers class'>" + appointments[i].split(".")[10] + "</p><p class='dataContainers clicked'>" + clicked + "</p><p class='dataContainers members'>" + appointments[i].split(".")[4].replace(/,/g, ', ') + "</p><p class='dataContainers daysFrom'>" + appointments[i].split(".")[0] + "</p></div>";


       switch (appointments[i].split(".")[0])
       {
          case "0":
          $("#dayOneEvents").append(appendString);
          break;
          case "1":
          $("#dayTwoEvents").append(appendString);
          break;
          case "2":
          $("#dayThreeEvents").append(appendString);
          break;
          case "3":
          $("#dayFourEvents").append(appendString);
          break;
          case "4":
          $("#dayFiveEvents").append(appendString);
          break;
          }
      }

  });

}

菲尔

获得以天为单位的时间差异的最简单方法是使用DateTime::diff...

$tz = new DateTimeZone('Your/Timezone'); // maybe this comes from the client side
$now = new DateTime('now', $tz);

// get event time as a DateTime object.
// Use DateTime::createFromFormat if the input format is non-US or ambiguous
$eventTime = new DateTime('date/time string from client', $tz);

$diff = $now->diff($eventTime);
$days = $diff->d;

当然,这只会为您提供两个日期/时间之间的实际整天数。DateInterval对象($diff)中还有许多其他与时间间隔相关的信息,例如

$hours = $diff->h;
$minutes = $diff->i;

更新

若要在每个日期的一天中开始工作,请在致电diff()...之前使用此功能

$now->setTime(0, 0);
$eventTime->setTime(0, 0);

$diff = $now->diff($eventTime);
$days = $diff->d;

注意:如果您的日期间隔超过夏令时阈值,您仍然可能会遇到问题

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章