Query Database Periodically Automatically PHP MYSQL

Question

This is a simple and straight forward question.I need to query my database every hour automatically. I know how to fetch the data, array them blah blah blah....... :-) the problem is I have to run the script manually. this is obviously not good programming practice and its boring. How do I do this automatically, do I need to run the script as a service? I am using Linux mint 9, php, mysql.

LOL, doing manually is just so wrong and I don't even think it can be achieved when you want to do it alone. You need to have same sleep! :P — Alfred
– Alfred, Commented Jan 17, 2011 at 10:28

Shakti Singh · Accepted Answer · 2011-01-17 09:30:40Z

4

You have to add cron job which will execute your PHP script every hour.

answered Jan 17, 2011 at 9:30

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

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

Comments

Flask · Accepted Answer · 2011-01-17 09:48:37Z

1

for example

0 * * * * php script.php

answered Jan 17, 2011 at 9:48

Flask

4,9841 gold badge23 silver badges39 bronze badges

Collectives™ on Stack Overflow

Query Database Periodically Automatically PHP MYSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related