PHP Time Ago Function

-
Time Ago Function is a function that is commonly used to display time in human understandable format, as you have seen many times on social networks, whenever you post any status on your Facebook, Twitter or any other network, it says posted few seconds ago, 1 min ago, 1 hour age, etc. This is actually done by subtracting the current time from the post published time.
//Creating Function
function TimeAgo ($oldTime, $newTime) {
$timeCalc = strtotime($newTime) - strtotime($oldTime);
if ($timeCalc >= (60*60*24*30*12*2)){
$timeCalc = intval($timeCalc/60/60/24/30/12) . " years ago";
}else if ($timeCalc >= (60*60*24*30*12)){
$timeCalc = intval($timeCalc/60/60/24/30/12) . " year ago";
}else if ($timeCalc >= (60*60*24*30*2)){
$timeCalc = intval($timeCalc/60/60/24/30) . " months ago";
}else if ($timeCalc >= (60*60*24*30)){
$timeCalc = intval($timeCalc/60/60/24/30) . " month ago";
}else if ($timeCalc >= (60*60*24*2)){
$timeCalc = intval($timeCalc/60/60/24) . " days ago";
}else if ($timeCalc >= (60*60*24)){
$timeCalc = " Yesterday";
}else if ($timeCalc >= (60*60*2)){
$timeCalc = intval($timeCalc/60/60) . " hours ago";
}else if ($timeCalc >= (60*60)){
$timeCalc = intval($timeCalc/60/60) . " hour ago";
}else if ($timeCalc >= 60*2){
$timeCalc = intval($timeCalc/60) . " minutes ago";
}else if ($timeCalc >= 60){
$timeCalc = intval($timeCalc/60) . " minute ago";
}else if ($timeCalc > 0){
$timeCalc .= " seconds ago";
}
return $timeCalc;
}
 
//Connecting Database
$connection = mysql_connect('localhost', 'root', '');
if (!$connection){
die("Database Connection Failed" . mysql_error());
}
$select_db = mysql_select_db('register');
if (!$select_db){
die("Database Selection Failed" . mysql_error());
}
$query_time="Select * from time_table where id=1";
$result_time = mysql_query($query_time);
$row_time = mysql_fetch_array($result_time);
$date = $row_time['trn_date'];
 
echo TimeAgo($date, date("Y-m-d H:i:s"));
?>

Comments

Post a Comment

Popular posts from this blog

Xampp MySQL not starting

-
Image
  If changing port number doesn't solve your problem, follow steps and this solves problem: (** By these steps don't need to reinstall Xampp or loss your database**) Stop all Xampp services and exit application. Move to c:\xampp\mysql Rename data folder to data_old create new data folder and copy whole content of backup folder to the data folder except "ibdata1"  5) Select all files in data_old folder and paste into data folder ( Note  Don't replace copied files and skip replace theme).
Read more

Multiple Login in Google Talk!

-
I wonder why this feature is not by default included in Google Talk. One can login simultaneously to more than one account. Unlike yahoo multiple login no need of registry editing here.Follow these simple steps.........* Create a shortcut of your Google talk.* Right click the shortcut ----> choose Properties.* In the "Target" you will find this "C:\Program Files\Google\Google Talk\googletalk.exe"* Now at the end of target add this "/nomutex" without the quotes. It should be like this "C:\Program Files\Google\Google Talk\googletalk.exe" /nomutex There is a space after googletalk.exe"Thats it .Click OK and you can open more than one Google talk.Amazing, isn't it?
Read more