Automate php and mySQL queries by time

Question

How can I run a php file or execute a mySQL query automatically depending on the time? For example, by 12mn I want my server to automatically run somefile.php.

More: I have a LAMP setup.

In unix, you can try use Cron. Other suggestion is create a .txt file that store last execution time, but is need too many visits, or a "infinite while" (server need support) — David Rodrigues
– David Rodrigues, Commented Nov 29, 2011 at 13:05

Shakti Singh · Accepted Answer · 2011-11-29 13:06:38Z

3

You are looking for the Cron jobs. you can schedule the PHP file to be executed with the cron and cron will take care of rest.

If you are on LAMP platform, check out how to setup cron.

answered Nov 29, 2011 at 13:06

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anonymous · Accepted Answer · 2011-11-29 13:06:16Z

0

Yes you can, just read something about cronjobs

answered Nov 29, 2011 at 13:06

Anonymous

3,6996 gold badges32 silver badges40 bronze badges

Comments

TeChn4K · Accepted Answer · 2011-11-29 13:09:47Z

0

You can do this by using Cron :

https://help.ubuntu.com/community/CronHowto

ex :

* */12 * * * php /cron/script.php

answered Nov 29, 2011 at 13:09

TeChn4K

2,4032 gold badges22 silver badges23 bronze badges

Comments

George P · Accepted Answer · 2011-11-29 19:13:10Z

0

If you don't want to setup a cron job (or if you can't) you can use a service like WebBasedCron

answered Nov 29, 2011 at 19:13

George P

7365 silver badges12 bronze badges

Collectives™ on Stack Overflow

Automate php and mySQL queries by time

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related