Executing a php script at Midnight every day? HELP!

I want to execute a script php to reset a mysql table every day at 0h00.

I tried to use CRON in Cpanel, but I don't know linux commands...


Can somebody help me with this and with turning the script protected?



Thanks, Hugo Alves.

 

You should create the mysql script that reset your database using PHP first. After which, you can set cron to execute the PHP script everyday.

 

The cron syntax should be:

0 0 * * * /usr/bin/php -f /home/USER/path/to/script.php

 

You can save yourself the trouble and just use Cronless to call the script for your automatically at midnight.

 

this tutorial might help

 

Your webhost should assist you with your request. This is the main advantage of using hosting services from a Managed WebHost who can serve you with all your technical issues in a timely manner.

 

You can use easycron.com, a super easy-to-use free cron job service.

 

Use a bash script, and run a cronjob to run it.