dongxinche1264 2014-12-30 00:21
浏览 7

如果是今天之后的日期,只显示活动?

I'm using PHP to insert events from a SQL database into a table in HTML, and I'm trying to make it only display future events (or events taking place the same day). The events are stored in the SQL database with "start" column having dates like 2014-12-25 00:00:00.

I was previously using this code to display all the dates:

while($row = mysql_fetch_array($result)){
    echo "<tr><td>" . $row['title'] . "</td><td>" . date("l, F d Y", strtotime($row['start'])) . " </td></tr>";
  }

And it worked fine. When I tried to compare the dates to yesterday (to ensure that events today would display) the HTML page was completely blank. Here's the code I'm using:

while($row = mysql_fetch_array($result)){
  if(strtotime("yesterday") < strtotime($row['start'])) {
    echo "<tr><td>" . $row['title'] . "</td><td>" . date("l, F d Y", strtotime($row['start'])) . "</td></tr>";
  }
}

I don't see anything wrong with this, but for some reason it works. I did some debugging and

strtotime($row['start']) outputs 1419483600

strtotime ("yesterday") outputs 1419742800

What am I doing wrong?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭
    • ¥15 2020长安杯与连接网探
    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么