Write some PHP/MySQL code

Write some PHP/MySQL code for Prestashop 1.7. Purpose to disable products obsolete products which are not comming from API anylonger.

Create PHP file check_products.php
$valid_porducts[] = file_put_contents('validproducts.txt', print_r($arr, true)); //reads valid products array;

SELECT * FROM ps_products; // reads all products from db
foreach (ps_products as product) // reads all products one by one and checks if they are valid
if (in_array("product.reference", $valid_porducts) AND product.virtual !=1) { //checks if product is not in array and if its not virtual
do Sql update ps_products set product.active=0 WHERE id_product=product.id_product; //deactivates product
do Sql Update ps_stock_available SET quantity=0 WHERE `id_product` = product.id_product //sets product quantity = 0
}