How to save HTML in database

Question

I have some question about saving html code in mysql database every time when I put the charter " ' " in the database it changes to " / ".

Example: somthing like that

<p>That's my name</p>

After saving it look like this:

<p>That\'s my name</p>

what can i do? thank u all

http://stackoverflow.com/questions/10848146/mysql-retrieving-a-html-table-from-the-database-backslashes-before-quotation — Sibiraj PR, Aug 23 '13 at 09:53
no need to do something, when you retrieve this string from DB it will show as it is. — Harshal, Aug 23 '13 at 09:53

score 5 · Accepted Answer · edited May 23 '17 at 11:58

Use parameterized queries to escape data going into the database
Use nothing else to escape data going into the database (otherwise you will double escape which can use this problem)
- Do not use mysql_real_escape_string
- Do not use addslashes
- etc
Do not escape data coming out of the database (since that will cause this problem)
Make sure magic quotes are disabled (since having them turned on will escape data going into and out of the database and cause this problem).

score 2 · Answer 2 · answered Aug 23 '13 at 10:07

2

You are using addslashes like escape functions in your code.

addslashes() — Quote string with slashes - http://php.net/manual/en/function.addslashes.php

stripslashes() — Un-quotes a quoted string - http://php.net/manual/en/function.stripslashes.php

answered Aug 23 '13 at 10:07

Balaji Kandasamy

4,446
10
40
58

score 0 · Answer 3 · answered Aug 23 '13 at 10:03

0

Use stripslashes to remove '\' from HTML data. Actually (') is used define string in MySql, so it ecaspe it (by putting \ in-front) in order to avoid any unintentional use.

answered Aug 23 '13 at 10:03

Vivek Raj

459
5
16

How to save HTML in database

3 Answers3