MySQL Forums
Forum List  »  PHP

Re: Removing HTML tags using mysql
Posted by: amit sankhala
Date: October 15, 2007 11:27PM

Hi hartmut,

Actually, data already stored within mysql database with <html> tags.
as what we did while inserting it with rich editor.

we need to show data as it is inserted with keeping all <html> tags.

but if we do, strip_tags() , it will remove all the <html> tags and hence by this, no tags will be displayed.

I want to display as html also and need to remove <html> tags while searching into database.

and if i will do this at php level, then i need to fetch all the data into array, then need to apply strip_tags on array, then search in it, and the need to sort the data which more time consuming and not performance oriented.that is why i cannot do this at php level.

Is there any other solutions at database level?

Thanks & Regards,
Amit Sankhala

Options: ReplyQuote

Written By
Re: Removing HTML tags using mysql
October 15, 2007 11:27PM
January 20, 2009 07:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.