[SOLVED] Find out if $Time passed since $date.

[shlomikalfa]

hey there i want to know what's the easiest way to do the following.

 

> Collect last update form server [MySql] in format: 2008-05-09 15:52:23

> Collect current time from php in format: date('Y-m-d H:i:s'), Should return same format.

> Check out if it's been 5 minutes since the last update.

 

Purpose: i have a server that holds all sort of variables in different tables, it also has a specific ''ServerDetails'' table to hold all the necessary details together, now i don't want to overload the server

with updating the details at every page watch so i want have a 'LastUpdate' variable which will be checked to see if it has been $X time from the last update then collect the details again...

 

IE:

Table1::
username | pass | something...
Table2::
Actions | ToDo | something....
ServerDetails::
Total users | Total Actions | Total something | last update

 

[move]Thanks for reading and supporting !!!!![/move]

[ILYAS415]

Hi. Theres a simple way to do it.

Use cron jobs.

 

http://www.siteground.com/tutorials/cpanel/cron_jobs.htm

[shlomikalfa]

well.. i don't see any cron jobs in my control panel [1and1]...

 

anyway to do what's PHPBB do for updating the ammount of users and so ?

[moselkady]

 

You can try something like this:

 

<?php
$row = mysql_query("SELECT last_update FROM ServerDetails");
$row = mysql_fetch_array($row);
if (time()-strtotime($row['last_update']) >= 300)
{
  // do updates
}
?>

[NorthWestSimulations]

as moselkady said StrToTime(); is the best function to use when dealing with time.