Help with automatic update of mysql using time()!

[dhimok]

Hey there. I have a question if u might help me

 

I want to update a database record using time as a trigger and I want this to happen automatically in the database thru a php file on the server.

 

 

lets say I have 2 time vars:

 

$now = time();
$expire = 1173697245;

what I want to accomplish is this:

if($now >= $expire) {

mysql_query("UPDATE table SET bla bla ");

}

 

I want this to be triggered autaomatically. How can I do that. How can I set a trigger?

[jcbarr]

That will only work if you access the page after the deadline. Then the script will execute the command.

 

I think what you want is a cron job.

[dhimok]

Hehe, I was just wondering if it is possible that php some how excesses the page and executes automatically right after $now >= $expire without having to use $_POST or $_GET Request and without actually browsing the page

[jcbarr]

That is what a cron job does. It will run the script at a specified time and execute the code that is contained within. Check with your host to see if you are able to set up these types of events.

[dhimok]

right now I am working on a local server so i can manage the server, how do I do that?

[jcbarr]

Now you have left my realm of knowledge. I have only done this using cPanel on a web host that I pay for, I have never actually managed my own server.

 

I'm sure someone will be able to asnwer that question though.

[dhimok]

Ok, I have cpanel as well. How do i set it up there?

[jcbarr]

Check this page, it has some good information on how to go about it in cPanel

 

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

[dhimok]

ok, thanks, I will check it out

[jcbarr]

For the command line, you would use something similar to this

 

php -q /home/serverpath/script/file.php

[dhimok]

Ok I will write that down