Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Removing HTML tags using a function

loci's profile image loci posted 2 months ago in General Permalink


I am trying to remove html formatting tags from data that is already in a table on the db. The data is used, with the formatting, to display on a web page but I also want to use the same data to output to a spreadsheet using the php functions for that task.

Both of the above work well except that I cannot remove the tags for the spreadsheet output so the <p> <br> etc show in the file. I tried php's strip_tags() function on the php side of things but that did not work.

I have tried using a sql function found here on the forum id 24766 (sorry cannot post a link yet)

but when I run it I get the following error - attached.

Any advice would be very welcome, thank you

(Heidi Version (64bit))

ansgar's profile image ansgar posted 2 months ago Permalink

Here's the link to your mentioned thread

loci's profile image loci posted 2 months ago Permalink

Thank you Ansgar

Please login to leave a reply, or register at first.