How to fix html string data in PHP and Mysql

Question

I am saving html data into mysql

like below

<p>&lt;div id=&quot;aaa&quot;&gt;asdadad&lt;/div&gt;</p>
<p>&lt;div id=&quot;aaa&quot;&gt;asdadad&lt;/div&gt;</p>
<div class="something">some data</div>

when showing the html as string in front end using php , it coverts all 3 lines(above) to html content not just string

But I expect the below result

first 2 line as string and 3rd line as html

I used:

html_entity_decode($content_from_db, ENT_QUOTES, 'utf-8');

Are you saying that PHP randomly added <p> tags to your string, for no reason? — cjds
– cjds, Commented Jan 7, 2013 at 1:49

Mike · Accepted Answer · 2013-01-07 01:51:49Z

0

Don't do anything to the data, just print it straight to the browser. If the data is stored as you say then you will get expected behaviour. If you don't get expected behaviour then either:

Data is not stored correctly, view it in MySQL console or a RDBMS
You are post-processing data after it is being pulled from DB

answered Jan 7, 2013 at 1:51

Mike

8,88710 gold badges53 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fix html string data in PHP and Mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related