What happens when HTML tags are inserted into mysql is escaped

The HTML code of a picture is escaped when it is inserted into MySQL, as follows

What causes this escape?
How to avoid this situation.
When this happens, use Html_entity_decode () to turn the following, or the HTML will be output as a string.

Reply content:

The HTML code of a picture is escaped when it is inserted into MySQL, as follows

What causes this escape?
How to avoid this situation.
When this happens, use Html_entity_decode () to turn the following, or the HTML will be output as a string.

It's not MySQL, let's find out why. It may be that the frame you use or the data submitted is escaped when filtered, and even the submitted data is already escaped, and it's not a big deal to follow.

If the general practice is to prevent XSS attacks such as non-escaped storage, such as database fields are stored

123

However, to prevent XSS attacks, HTML code escapes are performed at the time of Display Htmlspecialchars ()

So you have to first confirm that the PHP.ini method has no magic_quotes_gpc=on such configuration, if there is off, if this is already off
Then you have to follow the steps in the program to find escape code modifications

Inside what, you're not escaping, it's just a character entity.

So your problem is pseudo-proposition, MySQL will not take the initiative to help you do character entity operation, PHP may actively help you to escape operation (PHP.ini set Magic_quotes_gpc=on)

