$tdate=date("Y-m-d"); $a=date( "Y-m-d", mktime(0,0,0,date("m"),date("d")+3,date("Y"))); $sql="select * from memo where username='$session_user_id' and compid=$compid and telldate>='$tdate' and telldate<='$a' order by id desc"; $ret=mysql_query($sql,$conn); $a就是今天+三天的时间! $b=date( "Y-m-d", mktime(0,0,0,date("m"),date("d")-3,date("Y"))); $b就是今天-三天的时间!
$a=date( "Y-m-d", mktime(0,0,0,date("m"),date("d")+3,date("Y")));
$sql="select * from memo where username='$session_user_id' and compid=$compid and telldate>='$tdate' and telldate<='$a' order by id desc";
$ret=mysql_query($sql,$conn);
$a就是今天+三天的时间!
$b=date( "Y-m-d", mktime(0,0,0,date("m"),date("d")-3,date("Y")));
$b就是今天-三天的时间!
$days=abs((strtotime(date("Y-m-d"))-strtotime("xxxx-xx-xx"))/86400);
$days=abs((strtotime(date("Y-m-d"))-strtotime("xxxx-xx-xx"))/86400);
方法2:mktime函数返回的的是秒数,所以我们可以这样计算,
$date1="1992-03-05";
$date2="1992-04-05";
$result=round((mktime(0,0,0,4,5,1992)-mktime(0,0,0,3,5,1992))/3600/24)$result就是两个日期之间的天数差了
一种使用strtotime
还有一种通过秒数相减