if time is now is new hour then..

Hi,

Im trying to think of a way to write a piece of code that basiaclly does this.

If the time now is a new hour then...
If the time now is a new day then...
if the time is a new week then...
if the time now is a new month then...

once I have that I can create mysql tables at the right time to store data.

Thanks in advance!

That description is a bit cryptic. ^^

Do you want to check if it is a new hour since ANYBODY opened up the php page last time? Or just a specific IP? Or a user?

Anybody: Write information to text file, check text file with script.
IP / User: Use mysql table and write information for every ip/user in there. Check with script.

Sorry. I seem to be having one of those days where whatever I post I just confuse everybody.

No I want to get the php to check the server time and if the time is 15:59 then it is not a new hour since it last check at 15xx (stored in mysql table), but if the time was 16:02 then it would be a new hour so therefore continue.

Basically I need that to happen per hour, per day, per week, and per month.

Thanks.

Why not just use a cron job?

excuse my ignorance.... what is a cron job???

Whats going on, my post "use a cronjob" is gone... *grml* ^^

A Cronjob can be set at your webserver. It is a little timer (or more) which do something at a specific time.
You can set one "do stuff every hour" running one script, one "do stuff every 24hours" running another script.
Try Google: http://www.google.com/search?hl=en&q=cronjob

oh right yer i know what you mean now. The problem is that the script will be run on the server once every fifteen minutes.

But within the script itself I need it to write to different mysql tables depending on the date/time for hours/days/weeks and months. And I really want it to all run within the one script.

Thanks so far, but any more suggestions#?

Oh right, use the time() function.
http://uk2.php.net/time

ok cool. But back to my original question..

How would I implement that to work out if this is a new hour,day,week or month comparitive to the last time that each corresponding mysql table was updated??

Thanks again.

The MYSQL Table has some implemented informations. One is "update time". You can check at which something was added or modified.
So get that update time form your table with

PHP: Select all

$info = mysql_query("SHOW table status FROM yourdbname LIKE 'yourtablename'") or die (mysql_error());
$lastupdate = $info["Update_time"]; 

And then you can compare it to the actual time(); timestamp.

After a lot of coming and going. I have come to the conclusion that I need the script to activate certain parts of itself at different times of the day (the whole script will re run every 20secs) eg. run part a at 15:45 and 16:00, run part b at 9:00 and :9:30.

I hope someone can help me with this as I am stumped!

If you want the script to be executed at fixed times at the day, just get the current time

PHP: Select all

$time = date("H:i");
if($time == "15:45")
{
  // DO something at 15:45
}else
if($time == "09:00")
{
  // Do something at 9:00
}
... and so on!