<?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 `junk`=0 ORDER BY `adid` ASC LIMIT 500");
// $res_listing_query = $connect->query("SELECT * FROM `ads` WHERE `adid`=53164");
// $res_listing_query = $connect->query("UPDATE `ads` SET `junk`=0");
// echo "junk";
// die();

if($res_listing_query->num_rows > 0){
    echo '<pre>';
    while($row_listing = $res_listing_query->fetch_array(MYSQLI_ASSOC)){
        $adid = $row_listing['adid'];
        $description = $row_listing['description'];

        $description = utf8_encode(addslashes($description));
        // echo $description;
        // die();

        echo "<b>adid: </b> {$adid} - [updated]";
        

        // replace </ br> or </BR> to dot (.)
        // $sentence_arr = preg_replace("/\<br \/\>/", " . ", $description);
        // $sentence_arr = preg_replace("/<\/br>|<br\s?\/>/i", " . ", $description);
        
        $connect->query("UPDATE `ads` SET `description`='{$description}',  `junk`=1 WHERE `adid`='{$adid}'") || die('Update error: '.$connect->error);


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

    }
} else{
    echo "All completed";
}