[SOLVED] Create php file including one SQL statement

[oh_prestashop]

Hello,

 

I would like to create a single PHP file including just an SQL statement which needs to be executed regularly for maintenance purposes. The PHP file will then be called via CRON job.

 

How can I do this? 

 

Thank you very much in advance.

[tuk66]

Load PrestaShop config first

include(dirname(__FILE__).'/../config/config.inc.php');

and then you can create and execute an SQL query.

[PascalVG]

Here some examples:

https://www.prestashop.com/forums/topic/248621-solvedopen-and-close-store-at-set-times-each-day/?do=findComment&comment=1351867

 

Success!

 

pascal.

[oh_prestashop]

...works just fine!

Thanks @pascalVG

[PascalVG]

Perfect.

I'll mark it as solved.

 

Happy selling,

pascal.