Answers for "how to remove html tags in php from mysql"

php remove html tags

<?php
$text = '<p>Test paragraph.</p><!-- Comment --> <a href="#fragment">Other text</a>';
echo strip_tags($text);
//Test paragraph. Other text

// Allow <p> and <a>
echo strip_tags($text, '<p><a>');
//<p>Test paragraph.</p> <a href="#fragment">Other text</a>
// as of PHP 7.4.0 the line above can be written as:
// echo strip_tags($text, ['p', 'a']);
?>

php remove html tag

<?php
$str = "<h1>Hello WorldÆØÅ!</h1>";
# Remove all HTML tags and all characters with ASCII value > 127, from a string:
$newstr = filter_var($str, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);
echo $newstr;
# Result: Hello World!

mysql remove html tag

SELECT
REGEXP_REPLACE(posting_items.description, '<[^>]*>|&nbsp;', '') AS clean_description
FROM Table