<?php
header('Content-Type: text/html; charset=utf-8');
ini_set('max_execution_time', 300);
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';


// $res_listing_query = $connect->query("SELECT * FROM `ads` WHERE `done`=0 ORDER BY `id` ASC LIMIT 300");
$res_listing_query = $connect->query("SELECT * FROM `ads` WHERE `done`=0 ORDER BY `adid` ASC LIMIT 500");
// $res_listing_query = $connect->query("UPDATE `ads` SET `done`=0");
// echo "done";
// die();

if($res_listing_query->num_rows > 0){
    echo '<pre>';
    while($row = $res_listing_query->fetch_array(MYSQLI_ASSOC)){
        $adid = $row['adid'];
        echo "<b>adid</b>: ".$adid.PHP_EOL;

        $services_offered = '';
        $products = '';

        if(!empty($row['services_offered'])){

            if(!empty($row['services_offered'])){
               $services_offered = " || " . $row['services_offered'] . " || ";
            } else{
                $services_offered = " || " . $row['services_offered'];
            }
        }

        if(!empty($row['products'])){
            $products = $row['products'];
        }

        echo "services_offered: ".$services_offered.PHP_EOL;
        echo "products: ".$products.PHP_EOL;

        $merged_services = addslashes($services_offered . $products);
        
        echo "merged_services: ".$merged_services.PHP_EOL;

        $connect->query("UPDATE `ads` SET `services_products`='{$merged_services}', `done`=1 WHERE `adid`='{$adid}'") || die('Update error: '.$connect->error);

        echo PHP_EOL.PHP_EOL;


        echo '<meta http-equiv="refresh" content="3">';

    }
} else{
    echo "All completed";
}