mysql - How to run the PHP script at scheduled time

Question

I need to run a php script at the scheduled time daily to update some fields in database and to send automated email. How I can do this?

Is it possible to write some service in XAMP server to run the script daily at scheduled time? I have no idea how to update database and send email automatically at the scheduled time. Can any one share some ideas or concepts?

I am using PHP and MySQL running in Linux Server.

Answer 1

You should use a Cron job to do it. Check out the examples on the Wikipedia page.

The Cron Job should call a script using the php executable that runs the necessary task.