[n3wb!e]

hi, can someone provide me with a script to know the difference between two dates ? i searched everywhere but the info was vague. the problem is like this: i have a table which stores the date of the last login by user. i want this script to show after exactly how many days is the user loggin in(since his last login). please help me ! thanks in advance

[Christian]

Moved to Script Requests ....

[Keith]

I typed this up a while ago. Should work for you if you can convert the dates to a timestamp. If you don't have the timestamp available, you can convert pretty much any date format to a timestamp with http://www.php.net/mktime

Both parameters are UNIX timestamps. The first param is obviously the current time. The second param is the original recorded time you're comparing it to... so the first param will be larger than the second. If the first param is smaller, it will prepend a hyphen (negative sign).

It will display from years all the way down to seconds. It will display an increment of time only if it is greater than zero, so it will return something like

Code:

3 weeks, 2 days, 6 hours, 10 minutes, 34 seconds

So if the difference is 3 seconds more than a week, it will return only

Code:

1 week, 3 seconds

meaning it will NOT display useless data like

Code:

1 week, 0 days, 0 hours, 0 minutes, 3 seconds

If you don't want it to display too meticulously (like all the way down to seconds or minutes), just comment out or delete the blocks you don't want displayed (between their respective "Start" and "End" comments).

PHP Code:

<?php



function CalcDiff($currTime, $origTime)

{

    $showDiff = '';



    // Set times

    $currTime = intval($currTime);

    $origTime = intval($origTime);

    if ($currTime<$origTime) { $diff = $origTime-$currTime; }

    else { $diff = $currTime-$origTime; }



    // Start Years

    $yrs = floor($diff/31556926); // 31556926 secs/yr

    if ($yrs > 0)

    {

        $diff = $diff - ($yrs*31556926);

        $showDiff .= "{$yrs} year";

        $showDiff .= $yrs>1 ? 's' : '';

    }

    unset($yrs); // End Years



    // Start Months

    $mos = floor($difference/2629743.83); // 2629743.83 secs/mo

    if ($mos > 0)

    {

        $diff = $diff - ($mos*2629743.83);

        $showDiff .= empty($showDiff) ? '' : ', ';

        $showDiff .= "{$mos} month";

        $showDiff .= $mos>1 ? 's' : '';

    }

    unset($mos); // End Months



    // Start Weeks

    $wks = floor($diff/604800); // 604800 secs/wk

    if ($wks > 0)

    {

        $diff = $diff - ($wks*604800);

        $showDiff .= empty($showDiff) ? '' : ', ';

        $showDiff .= "{$wks} week";

        $showDiff .= $wks>1 ? 's' : '';

    }

    unset($wks); // End Weeks



    // Start Days

    $days = floor($diff/86400); // 86400 secs/day

    if ($days > 0)

    {

        $diff = $diff - ($days*86400);

        $showDiff .= empty($showDiff) ? '' : ', ';

        $showDiff .= "{$days} day";

        $showDiff .= $days>1 ? 's' : '';

    }

    unset($days); // End Days



    // Start Hours

    $hrs = floor($diff/3600); // 3600 secs/hr

    if ($hrs > 0) {

        $diff = $diff - ($hrs*3600);

        $showDiff .= empty($showDiff) ? '' : ', ';

        $showDiff .= "{$hrs} hour";

        $showDiff .= $hrs>1 ? 's' : '';

    }

    unset($hrs); // End Hours



    // Start Minutes

    $mins = floor($diff/60); // 60 secs/min

    if ($mins > 0) {

        $diff = $diff - ($mins*60);

        $showDiff .= empty($showDiff) ? '' : ', ';

        $showDiff .= "{$mins} minute";

        $showDiff .= $mins>1 ? 's' : '';

    }

    unset($mins); // End Minutes



    // Start Seconds

    if ($diff > 0)

    {

        $showDiff .= empty($showDiff) ? '' : ', ';

        $showDiff .= "{$diff} second";

        $showDiff .= $diff>1 ? 's' : '';

    } // End Seconds



    unset($diff); // Free unused memory



    // Return difference

    if ($currTime<$origTime) { $showDiff = "- {$showDiff}"; }

    return $showDiff;

}



// Examples:

echo CalcDiff(234892574923, 234892374923); // 2 days, 7 hours, 33 minutes, 20 seconds

echo CalcDiff(234892344923, 234892374923); // - 8 hours, 20 minutes

echo CalcDiff(2394534924, 2392374923); // 3 weeks, 4 days, 1 second



?>

[n3wb!e]

thanks dude.. thanks a ton.