How to write a time ago function in mysqli using data from database?

PHP
1

Im a newbie in php. Any help will be appreciated.

2

MySQL already comes with a bunch of date/time functions built-in: https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

1 Like
3

i was thinking of how they do in facebook like , time ago function. though lol

4

this is just a matter of displaying a time difference. http://php.net/datetime can help you with that as well.

5

yeah, i’ve been through a lot of sites to find this one, none of them is the one am looking for thats why im here sir! lol

6 
<?php

$time_elapsed = timeAgo($time_ago); //The argument $time_ago is in timestamp (Y-m-d H:i:s)format.

//Function definition

function timeAgo($time_ago)
{
    $time_ago = strtotime($time_ago);
    $cur_time   = time();
    $time_elapsed   = $cur_time - $time_ago;
    $seconds    = $time_elapsed ;
    $minutes    = round($time_elapsed / 60 );
    $hours      = round($time_elapsed / 3600);
    $days       = round($time_elapsed / 86400 );
    $weeks      = round($time_elapsed / 604800);
    $months     = round($time_elapsed / 2600640 );
    $years      = round($time_elapsed / 31207680 );
    // Seconds
    if($seconds <= 60){
        return "just now";
    }
    //Minutes
    else if($minutes <=60){
        if($minutes==1){
            return "one minute ago";
        }
        else{
            return "$minutes minutes ago";
        }
    }
    //Hours
    else if($hours <=24){
        if($hours==1){
            return "an hour ago";
        }else{
            return "$hours hrs ago";
        }
    }
    //Days
    else if($days <= 7){
        if($days==1){
            return "yesterday";
        }else{
            return "$days days ago";
        }
    }
    //Weeks
    else if($weeks <= 4.3){
        if($weeks==1){
            return "a week ago";
        }else{
            return "$weeks weeks ago";
        }
    }
    //Months
    else if($months <=12){
        if($months==1){
            return "a month ago";
        }else{
            return "$months months ago";
        }
    }
    //Years
    else{
        if($years==1){
            return "one year ago";
        }else{
            return "$years years ago";
        }
    }
}

?>

So how do i use this with database, i got no idea, any help please

7

you get the timestamp out of the database and call the function with it. Although I would like to add that this function doesn’t handle leap years (which DateTime would offer).

1 Like
8

could you show me an example of leap year sir please/

9

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.