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 11 months ago in General Permalink

Hi,

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 10.1.0.5464 (64bit))

ansgar's profile image ansgar posted 11 months ago Permalink

Here's the link to your mentioned thread

loci's profile image loci posted 11 months ago Permalink

Thank you Ansgar

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




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.