get the date how long it get post

[mikhell]

I try to get how long my message was sent with this...

 

        $Now						= strtotime ("now");
$dateEnvoi					= $fetchDiscussion['dateEnvoi']; //my date from my DB
$timeEnvoi					= mktime($dateEnvoi);
$TempsEnvoi					= $dateNow - $dateEnvoi;

 

and it try to get how long it was post ... same thing as on facebook... like the 26 minutes ago from FB how can i do it ?

 

[mikhell]

no body are able to ?

[Buddski]

So you are trying to calculate how long ago a post was made?

How is the date stored in your database? a date format like 2010-04-01 or and integer?

[mikhell]

Yep... but is my way is ok ? or i'm lost ? and how can i do it simple as possible ?

[Buddski]

It all depends on how the data in the database is stored as how I can help you proceed.

 

If it is stored as a DateTime use this

// If it is stored as a DateTime use this
$stored_date = strtotime($fetchDiscussion['dateEnvoi']);
$time_diff = time() - $stored_date;
// If stored as a unix timestamp use this
$time_diff = time() - $fetchDiscussion['dateEnvoi'];

Then use PHP date function to display the date correctly.

http://php.net/manual/en/function.date.php

 

[mikhell]

if its a timestamp...  :-\ should i change it for a datetime ?

[Buddski]

Doesnt really matter. Both ways can be processed by PHP.

[mikhell]

Thank you very much man !!! 

[mikhell]

$dateEnvoi					= $fetchDiscussion['dateEnvoi'];
$stored_date				        = strtotime($fetchDiscussion['dateEnvoi']);
$tempsDiff 					= time() - $stored_date;

 

How can i convert it to minute like : $tempsDiff / 60 = minutes ?

[mikhell]

I GOT IT !!! THANK YOU SOOOO MUCH MAN ! i'm very happy 

[mikhell]

How can I get the day like monday or thursday in string? and how for the today date ?