PHP - MySQL data is html code and php doesn't show correctly

Question

I have some values in my database which a column named description contains HTML CODE ex. (<p> </p><div class="col-xs-8">..).

I get the database rows and try to show it in the page, all the columns displays normal (as it is plain text) BUT when I echo the variable that contains description value it doesn't turn the code into "page", it only shows the code.

Where is the problem? Shouldn't it consider as code as well and add it to the page?

CODE:

<div class="info">
   <div class="info-space" style="width: 800px;"></div>
        <?php
            echo $pro_desc;
        ?>
    </div>
</div>

The database is holding a string, not markup. You have to store it in such a way so as to return the markup. — Jay Blanchard
– Jay Blanchard, Commented May 14, 2015 at 17:47
when you view the html source that your php page echoed, (ctrl+u) what does the html look like? — RightClick
– RightClick, Commented May 14, 2015 at 17:47
@RightClick it shows with a double quote in the beginning "<p> </p><div class="col-xs-8">... — alexandreferris
– alexandreferris, Commented May 14, 2015 at 17:49
@tuananh result of var_dump: string '<p> </p><div class="col-xs-8"...length(25000) — alexandreferris
– alexandreferris, Commented May 14, 2015 at 17:50

Tuan Anh Hoang-Vu · Accepted Answer · 2015-05-14 17:57:24Z

1

Your $pro_desc looks like this:

string '&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div class=&quot;col-xs-8&quot;...length(25000)

In order to display it correctly, you need to convert it to HTML format, for example <p> to <p> and so on. Try this:

echo "<p>".html_entity_decode($pro_desc)."</p>";

More info: http://php.net/manual/en/function.html-entity-decode.php

edited May 14, 2015 at 17:57

answered May 14, 2015 at 17:52

Tuan Anh Hoang-Vu

2,0151 gold badge22 silver badges32 bronze badges

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

7 Comments

alexandreferris Over a year ago

So, it worked as I expected. (I have had read about it before). BUT is there any other option to make it work? As in, doing something in the database?

Jay Blanchard Over a year ago

Why would you need another option @holpducki?

alexandreferris Over a year ago

@JayBlanchard so I can have it configured in the database and not in my PHP/HTML files.

alexandreferris Over a year ago

I will mark your answer as correct as it fixed my problem. But im still looking for anther option of fixing it. Thank you

Jay Blanchard Over a year ago

there is no other option @holpducki

|

Jorge Luis Jiménez · Accepted Answer · 2015-05-14 17:54:27Z

0

It's important that you try this code:

htmlspecialchars($_POST['description'] , ENT_QUOTES);

before you save your description in the database and when you need to fetch this field use :

htmlspecialchars_decode($data['description']);

You can read more here. http://php.net/htmlspecialchars

answered May 14, 2015 at 17:54

Jorge Luis Jiménez

1,31813 silver badges21 bronze badges

2 Comments

alexandreferris Over a year ago

Do you have another option? As in configuring the database column?

Jorge Luis Jiménez Over a year ago

I used that before and I implement this code [Html_Page] [nvarchar](max) NULL, in sqlserver. In Mysql you need to use a Text field. dev.mysql.com/doc/refman/5.7/en/blob.html

Collectives™ on Stack Overflow

PHP - MySQL data is html code and php doesn't show correctly

2 Answers 2

7 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related