Need help in removing html tag

mks_mishra

Hello frnds plz help me
in my datbases their is field news & it's dat is shown here it has datatype of text

<pre>this is news3 </pre>
this is part of news3,
this is second line of news 3

i want to disply the data after removing html tag.
plz help me

----------------------------------------------Here is code but mistake is their---------------------
from database having text datatype

$newsline=<pre>this is news3 </pre>

print "$newsline"; //<pre>this is news3 </pre>

$news=strip_tags($newsline);
print "$news"; //output::<pre>and content iof news</pre>

I want to remove this <pre> tag i.e. I want to removw html tag from text datatype column

leatherback

Hi,

I am not sure whether the <pre> </pre> falls within the scope of strptags. If it does, this should help:

$news=strip_tags(htmlentities($newsline));

mks_mishra

it gives out put like this==> <pre>this is news3 </pre>

leatherback

leatherback wrote:
Hi,

I am not sure whether the <pre> </pre> falls within the scope of strptags. If it does, this should help:

$news=strip_tags(htmlentities($newsline));

My bad,
wrong section in the manual.
$news=strip_tags(html_entity_decode($newsline));

mks_mishra

hey it solved my problem .thanks
even i got the solution of yesterday's problem
Here i m giving solution

of yesterday problem of single line frm mysql field of text datatype :
explode("\n",$result[$cntA]) using php

& this is using mysql::>>

SELECT
substring(FieldName,1,locate('\n',FieldName))
FROM tableName

http://dev.mysql.com/doc/mysql/en/string-functions.html

date format:
SELECT date_format(current_date,'%M %d, %Y')

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

::>>>thi s is another solution of removing html tags:::::
$search = array ('@<script[^{>]?>.?</script>@si',} // Strip out javascript
'@<[\/!]?[^<>]?>@si', // Strip out HTML tags
'@([\r\n])[\s]+@', // Strip out white space
'@&(quot|#34);@i', // Replace HTML entities
'@&(amp|#38);@i',
'@&(lt|#60);@i',
'@&(gt|#62);@i',
'@&(nbsp|#160);@i',
'@&(iexcl|#161);@i',
'@&(cent|#162);@i',
'@&(pound|#163);@i',
'@&(copy|#169);@i',
'@&#(\d+);@e'); // evaluate as php

$replace = array ('',
'',
'\1',
'"',
'&',
'<',
'>',
' ',
chr(161),
chr(162),
chr(163),
chr(169),
'chr(\1)');

$news = preg_replace($search, $replace, $newsline);

Have fun dude
thanks once again