Menu
Community /Pin to ProfileBookmark
@NogDogDec 10.2004 — #Something like this?
@NogDogDec 10.2004 — #
I was assuming it would be run as a command line program, not as a web page request. But we all know what happens when you assume.... ?
How to build a database updater?
I was wondering how would someone go about coding a ticker program that can (at every hour of xx:00:00), update a table of the database based on a certain row?
Okay, lemme change the question. How do you build a program that can run on the background (something that relates to a cronjob, but isn’t a cronjob) to update rows every hour?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogDec 10.2004 — #Something like this?[code=php]
<?php
$intervalMinutes = 60; # how often to do it in minutes
$precisionSeconds = 60; # how precisely to check if it's time for next one
$lastRun = time() - ($intervalMinutes * 60);
while(TRUE) # <<<--- warning: infinite loop
{
if(time() >= $lastRun + ($intervalMinutes * 60) )
{
$lastRun = time();
#
# do your database stuff here
#
}
sleep($precisionSeconds);
}
?>
[/code]0
@NogDogDec 10.2004 — #[i]Originally posted by pyro [/i]
[B]What happens when your PHP script times out? Also, for obvious reasons, I wouldn't recommend doing it that way at all... [/B][/QUOTE]
I was assuming it would be run as a command line program, not as a web page request. But we all know what happens when you assume.... ?