Categorize database rows by time

Question

how can i categorize database rows by

today

yesterday

last 7 days

last 30 days

i will just get Datetime. I dont now how to use it after getting it. No need for DB structure. — Webber Depor, Dec 04 '15 at 19:33
Possible duplicate of [How to check if a date is in a given range?](http://stackoverflow.com/questions/976669/how-to-check-if-a-date-is-in-a-given-range) — , Dec 05 '15 at 07:29
if you already have a Datetime object, you may want to take a look at the third highest answer http://stackoverflow.com/a/9065661/5051310 — , Dec 05 '15 at 07:30
Don't forget to mark as an Accepted Answer with the green check mark below the up and down arrows. If it solved your problem. That's how we roll on the stack. — Drew, Mar 03 '16 at 02:49

im_tsm · Answer 1 · 2015-12-06T13:26:08.087

1

Here is a function for checking post time:

$post_time1 = strtotime("05 December 2015");
$post_time2 = strtotime("02 December 2015");

check_post_time($post_time1);
check_post_time($post_time2);

function check_post_time($time) {
    $before_24 = strtotime("-1 day");
    $before_1week = strtotime("-1 week");
    $before_1month = strtotime("-1 month");
    if($time >= $before_24)
        echo "24hr ago";
    elseif($time >= $before_1week)
        echo "between 24hr - 1 week ago";
    elseif($time >= $before_1month)
        echo "between 7 days - 1 month ago";
    else
        echo "1 month ago";
}

edited Dec 06 '15 at 13:26

answered Dec 04 '15 at 20:04

im_tsm

1,965
17
29

sorry for late. when i write strotime("-1 week"), does it includes ("-1 day")? or, does ("-1 month") includes ("-1 week") and ("-1 day")? – Webber Depor Dec 04 '15 at 21:31
strotime("-1 week") just gives the timestamp of day which is 7 days back from today.I am using if else ladder to find the range. – im_tsm Dec 04 '15 at 21:39
("29 Nowember 2015") turns 1 month ago instead of 7 day-1 month ago – Webber Depor Dec 04 '15 at 22:39
in your second elseif, `$time >= $time` is always true – Dec 05 '15 at 07:27
Sorry for the typo it will be $before_1month – im_tsm Dec 06 '15 at 13:25

Md Mazedul Islam Khan · Answer 2 · 2015-12-05T07:24:02.927

You can use Carbon PHP package to display your time in human readable way. This package is very popular and it even included on the Laravel framework.

You can install the package using Composer. Once you installed this package you can use it by following like this:

<?php
require 'vendor/autoload.php';

use Carbon\Carbon;

printf("Now: %s", Carbon::now());

// Human readable way
echo Carbon::now()->subMinutes(2)->diffForHumans(); // '2 minutes ago'

Categorize database rows by time

2 Answers2