Strip HTML Tags From Search Results

Question

When I make a search, if there is an image title within a img tag, it's displayed in a very ugly fashion among the search results (the whole tag is displayed and the picture too). I found this script which is supposed to solve the problem and this is the only thing I found about the subject over the internet.

<?php
function super_search_exclude_activate() {
    $striptags = "CREATE FUNCTION fnStripTags( Dirty longtext )
        RETURNS longtext
        DETERMINISTIC 
        BEGIN
          DECLARE iStart, iEnd, iLength int;
            WHILE Locate( '<', Dirty ) > 0 And Locate( '>', Dirty, Locate( '<', Dirty )) > 0 DO
              BEGIN
                SET iStart = Locate( '<', Dirty ), iEnd = Locate( '>', Dirty, Locate('<', Dirty ));
                SET iLength = ( iEnd - iStart) + 1;
                IF iLength > 0 THEN
                  BEGIN
                    SET Dirty = Insert( Dirty, iStart, iLength, '');
                  END;
                END IF;
              END;
            END WHILE;
            RETURN Dirty;
        END;";
    global $wpdb;
    $wpdb->query("DROP FUNCTION IF EXISTS fnStripTags");
    $wpdb->query($striptags);
}
register_activation_hook(__FILE__, 'super_search_exclude_activate');

function super_search_exclude_deactivate() {
    global $wpdb;
    $wpdb->query("DROP FUNCTION IF EXISTS fnStripTags");
}
register_deactivation_hook(__FILE__, 'super_search_exclude_deactivate');

function super_search_exclude_posts_search($search) {
    if (is_search()) {
        global $wpdb;
        if (stripos($search, 'post_content LIKE')) {
            $search = str_replace("{$wpdb->posts}.post_content LIKE", "fnStripTags({$wpdb->posts}.post_content) LIKE", $search);
        }
    }
    return $search;
}
add_filter('posts_search', 'super_search_exclude_posts_search');

I don't have any error message but the search engine doesn't return a result unless I deactivate the plugin and then I'm back to square one.

What would be the issue?

PS: I created a plugin from this script and activated it in the right admin section.

Answer 1

I don't know about the code you are trying to use, personally I would never use a solution that excludes results, it's very possible the item being searched for is in those results and excluding them is only a degradation of service.

Instead you can use the search.php template file to adjust how your search results are displayed, there is a very handy function available in php called strip_tags() which will remove all HTML tags from a string.

UPDATE:

Specifically:

search.php:

<?php
/**
 * Template Name: Search Results Page
 */
get_header();
?>
<section id="primary">
    <div id="content" role="main">
        <?php if (have_posts()): ?>
            <header class="page-header"><?php _e("Search Results"); ?></header>
            <div class="entry-content">
                <?php
                while (have_posts()): the_post();
                    echo strip_tags(get_the_content());
                endwhile;
                ?>
            </div>
        <?php endif; ?>
    </div>
</section>
<?php
get_footer();

Answer 2

why not create a clear (non html) verson fo post while saving (save_post hook) and place it to additional field of psots tabel (delta tables) and search by this field while searching site (posts_where_request filter hook).