我尝试了堆栈溢出时可用的大部分功能,但似乎没有任何作用.
i tried most of what is available on stack overflow but none seem to work.
我尝试比较两种方式(日期和时间格式).并计算它们之间的差异是否在5秒钟之内
any way i am trying to compare two (date and time formats). and calculate whether their difference is within 5 seconds of each other
第一个日期是当前日期:
the first date is the current date:
$today = date("Y-m-d H:i:s");第二个日期取自mysql数据库:
the second date is taken from mysql database:
$result = mysql_query("SELECT * FROM BUS_DATA where BusRegID = 'bus'") or die(mysql_error()); $row = mysql_fetch_array($result); $update_date = $row["update_date"];答案应分为年,月,日,小时,分钟和秒.
the answer should be segmented into years , month , days , hours , minutes ,and seconds portions.
我正在运行PHP版本5.3.3
I am running PHP Version 5.3.3
大多数答案只给出时间范围内的结果,我想检查日期是否匹配,然后比较一天中的时间是否在5秒以内,所以请比你们提前:)
most answers give result in time frame only , I want to check whether the date matches , then compare if the time of the day is within 5 seconds , than you guys in advance :)
推荐答案使用strtotime,它几乎可以理解任何日期格式:
use strtotime, it's understands almost any date formats:
$timeDiff = abs(strtotime($today) - strtotime($update_date));这为您提供了以秒为单位的日期之间的时差.
this gives you the difference between dates in seconds.
更多推荐
返回两个(日期和时间)PHP之间的时差
发布评论