How to make a php script inserted into a page through a "require" run from time to time?

Question

In the answers to question of the link below I posted how I managed to delete from the database the user information that not activate in up to 24h your registration through the link sent to your email:

How to delete the database registration if the user does not activate it by email within "X" hours?

On my login homepage I put the function

$revisa = vinte_e_quatro(); 

Now every time my homepage is loaded the script will run. How to make it run only once a day, for **week...?

DOUBT

My function to check whether or not the user activated his registration in 24h is this:

require 'config.php';  
require 'connection.php'; 
require 'database.php'; 
<?php
//Exclui linhas não ativadas em até 24h
function vinte_e_quatro () {     
$tempo_agora = time(); 
$query = DBDrop('myway', "ativo='0' AND (data_ts + 86400) <= '$tempo_agora' "); 
}
$revisa = vinte_e_quatro();
?>

Should I do a cron job for the page where I created this function and that’s it? Just wait for it to turn automatically...

Answer 1

Assuming your code is already working correctly, you can include this query at the beginning of the website homepage, for example:

index php.

<?php
require 'config.php';  
require 'connection.php'; 
require 'database.php'; 

//Exclui linhas não ativadas em até 24h
$query = DBDrop('myway', "ativo='0' AND (data_ts + 86400) <= '" . time() . "' "); 

// restante o seu código.
// ...

You have no problem executing this query on all requests, unless your database has millions of records of course...

And consider indexing active fields and data_ts if the table has many fields.

---

If you need to configure the task with a cronjob, try the command below:

35 20 * * * lynx -dump http://dominio/arquivo.php

In this example, it runs every day at 20:35

Answer 2

If your server has CPANEL, you can set up a "cronjob", just search the panel and configure how long the file or url should run, and use something like:

curl -s -o /dev/null http://seusite.com.br/arquivo.php

Answer 3

You can use cron job, as the staff commented. Or also an option you can do not to run the same code every time when someone opens your page:

• It can be done whenever someone activates an account, for example, you delete all database records that have been made for more than 24 hours. You can use this check for example:

  date_add(data_ts, interval 1 day) <= now() and ativo = 0

Which will add 1 day in "data_ts" and if the result is less than the current date/time, delete from the database.