从MySQL数据库列中的数据条带化HTML

Question

Probably based on this question: Best way to strip html tags from a string in sql server?

Think of me as a noob. I have a field with data in it. I need to strip html from this column and I'm aware that there is a PHP function that does this. What do I do to do this in my SQL database?

What do I enter for the query? Select my column (the field I call it) from the table...and then?

Answer 1

Using strip_tag() function

// assuming that you're using MySQL
$result = mysqli_query("SELECT column FROM table");
while ($row = mysqli_fetch_array($result)) {
  echo strip_tags($row['column']) . '<br />';
}

or using preg_replace() function and this simple regular expression <[^>]*>

echo preg_replace('/<[^>]*>/', '', $row['column']);

Working PHP demo

Recomended method: strip_tags() function in this case. It takes two arguments; the first one is the text itself and the second one contains allowed tags; so, for instance, if you want to keep <a> and clean everything else you simply use it like this:

strip_tags($text, '<a>');