I need to run a cron job to do a sql query and save the data in the database every 24 hours.
I have a controller called GetproductsController.php and the method I have to execute is indexAction()
I've tried to do it this way:
59 23 * * * cd /var/www/html/proyecto/getproductscontroller.php index
But I don´t know how to do it, If anyone knows how I can do it, I would appreciate it.