Posted by Stephen Leaf on 10/22/45 11:27

$date = mysql date field 2005-09-23 for example
$difference =ceil((strtotime($date) - time()) / 86400);

strtotime is far nicer than mktime when you already have a date field ready.

On Friday 23 September 2005 03:10 pm, Philip Thompson wrote:
> On Sep 23, 2005, at 11:16 AM, Chris W. Parker wrote:
> > Philip Thompson <mailto:prthomp@uark.edu>
> >
> > on Friday, September 23, 2005 9:12 AM said:
> >> I'm needing to find the number of days between two dates without
> >> using an database functions (DATE_SUB, etc)... only PHP. Is there an
> >> easy way to accomplish this? I have searched the PHP site, but have
> >> not been successful in finding anything that will assist me.
> >>
> >> Any help would be appreciated.
> >
> > There might be an easier way but... convert to timestamp, subtract
> > smaller number from bigger number, figure out how much time has
> > passed.
> > Chris.
>
> I actually discovered how to do this right after I made the post. I
> looked at some archives and worked this out.
>
> <code>
>
> // today - 9/23/05
> $start = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
>
> // the objective day - 3/15/06
> $end = mktime(0, 0, 0, 3, 15, 2006);
>
> // subtract today from the objective and divide by 24*60*60 to get days
> $difference = ceil(($end - $start) / (86400));
>
> </code>
>
> Thanks for your assistance.
> ~Philip

[Back to original message]