Tool for searching through my WordPress blog for posts with hashtags or handles in WordPress titles

parse-resulting-csv-on-a-php-page.php

<?php

function find_tags($str) {
    $tags = [];
    $words = explode(" ", $str);
    foreach ($words as $word) {
        if (substr($word, 0, 1) === "#") {
            $value = strtolower(str_replace([".",":","#","!","\"", "@", "(", ")"],"",$word));
            if (strlen($value) > 2) {
                $tags[] = $value;
            }
        }
    }
    return implode(" ", $tags);
}

function find_atsigns($str) {
    $tags = [];
    $words = explode(" ", $str);
    foreach ($words as $word) {
        if (substr($word, 0, 1) === "@") {
            $value = strtolower(str_replace([".",":","#","!","\"", "@", "(", ")"],"",$word));
            if (strlen($value) > 2) {
                $tags[] = $value;
            }
        }
    }
    return implode(" ", $tags);
}


$lines = file("out.csv");

foreach ($lines as $line) {
    $parts = explode(",", $line);
    $id = array_shift($parts);
    $title = implode($parts, ",");
    $tags = find_atsigns($title) . " " . find_tags($title);
    
    if ($tags) {
        echo <<<WHAT
wp post term add {$id} post_tag $tags
WHAT;

//    echo $title;
        echo "<br>";
    }

}

wp-cli-search-for-at-mentions.sh

# https://developer.wordpress.org/cli/commands/post/
wp post list  --post__in=$(wp db query 'SELECT ID FROM artlungblog_posts WHERE \
post_title LIKE "%@%" AND post_status="publish" AND post_type="post"' \
--skip-column-names |  paste -s -d ',' - ) --format=csv --fields=ID,post_title > out.csv

wp-cli-search-for-hashtags.sh

# https://developer.wordpress.org/cli/commands/post/
wp post list  --post__in=$(wp db query 'SELECT ID FROM artlungblog_posts WHERE \
post_title LIKE "%#%" AND post_status="publish" AND post_type="post"' \
--skip-column-names |  paste -s -d ',' - ) --format=csv --fields=ID,post_title > out.csv