<?php
  ini_set('max_execution_time', 300);

  $path  = $_SERVER['DOCUMENT_ROOT'];
  
  include_once $path.'/connect_db.php';

  
    // Execute query
    $sql = "SELECT * FROM `google_suggest` where `junk` = 0 order by `id` LIMIT 300";
    // $sql = "SELECT * FROM `google_suggest` where keyword LIKE '%/%' LIMIT 10";
    $result = $connect->query($sql);

    if ($result->num_rows > 0) {
        // Process the results
        while ($row = $result->fetch_assoc()) {

            $id = $row['id'];

            $keyword = $row["keyword"];
            $keyword_singular = $row["keyword_singular"];
            $keyword_plurals = $row["keyword_plurals"];
        
            $keyword = preg_replace("/\//", "", $keyword);
            $keyword_singular = preg_replace("/\//", "", $keyword_singular);
            $keyword_plurals = preg_replace("/\//", "", $keyword_plurals);
            
            echo "<pre>";
            echo "id : " . $id . "<br/>";
            echo "keyword: ".$row["keyword"]." -> ".$keyword."<br>";
            echo "keyword_singular: ".$row["keyword_singular"]." -> ".$keyword_singular."<br>";
            echo "keyword_plurals: ".$row["keyword_plurals"]." -> ".$keyword_plurals."<br>";
            echo "</pre>";

            $keyword = addslashes(trim($keyword));
            $keyword_singular = addslashes(trim($keyword_singular));
            $keyword_plurals = addslashes(trim($keyword_plurals));
        
            $sql = "UPDATE `google_suggest` SET `keyword`='$keyword',`keyword_singular`='$keyword_singular',`keyword_plurals`='$keyword_plurals', junk = 1  WHERE id='$id'";
            $connect->query($sql) || die("Error: ".$connect->error);
        }
        
        echo '<meta http-equiv="refresh" content="0">';
    }else{
        echo "completed";
    }

    // Close the connection
    $connect->close();
?>