Question

This question already has answers here:

Possible Duplicate:
How to calculate the difference between two dates using PHP?
How to find number of days between two dates using php
How to find the dates between two specified date?

i 本表有三个领域

 seeker
 name ....current_time.... login_date

second field i have created through timestamp phpmyadmin
type: timestamp
default: current_timestamp

当申请人登记时——时间自动插入时间段

 third field is login_date filed. when user logins then this field is updated 

//login date
$login_date = date("Y-m-d");
echo "login date"."".$login_date;
$qry1 = "update seeker set login_date =  $login_date  where name= $uname ";
$res1=mysql_query($qry1,$con);

now current_date is like 
"2012-04-10 21:58:01"

and login_date is like
"2012-05-02"

i 希望在这两个日期之间找到天数。 i 确切知道如何将这些日期细分,因为目前——日期也包括时间。或以任何其他方式将时间排除在目前期限之外,即该时限仅于非时间日期。

Answer 1

 $login_date = strtotime(x); // change x with your login date var
 $current_date = strtotime(y); // change y with your current date var
 $datediff = $current_date - $login_date;
 $days = floor($datediff/(60*60*24));

友情链接