How can I display a string output from mySQL with CakePHP?

Question

I have a database system set up to store and output pages and posts in my CMS, however I am getting this returned from the database:

&lt;p&gt;&amp;lt;iframe width=&quot;854&quot; height=&quot;480&quot; src=&quot;https://www.youtube.com/embed/PMf6PjVXRtc&quot; frameborder=&quot;0&quot; allowfullscreen&amp;gt;&amp;lt;/iframe&amp;gt;&lt;/p&gt;

At this point I have removed all encoding - it's just a straight CakePHP ->Save, and this appears to be the result of CakePHP's data sanitization.

        $this->save(
            array(
                'contentBody' => $data["contentBody"]
            ),
            false
        );

On the output side, what can I do to properly display this encoded HTML? The output may include regular echo or print, as well as a TinyMCE textarea.

Furqan Aziz · Accepted Answer · 2015-11-28 15:30:52Z

1

You have to use html_entity_decode() before doing output. Lets say you are having output html in a variable $str use the following like for outputting:

echo html_entity_decode(html_entity_decode($str));

edited Nov 28, 2015 at 15:30

answered Nov 28, 2015 at 14:45

Furqan Aziz

1,1149 silver badges18 bronze badges

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

7 Comments

Merlin Over a year ago

I already am in one spot at least, that produces this: <iframe width="854" height="480" src="youtube.com/embed/PMf6PjVXRtc" frameborder="0" allowfullscreen></iframe> I have a feeling I'm missing something else as well.

Merlin Over a year ago

Okay, using echo html_entity_decode($Post['Post']['contentBody']); on a plain HTML page produces the above string instead of the expected iframe output, which should display a Youtube embedded video.

Furqan Aziz Over a year ago

I have edited my code above. Use html_entity_decode() twice on the string because cake php is encoding twice. If you find your solution mark my answer as solved and vote it up :) Thanks

Merlin Over a year ago

Well that's one part of the issue solved. I did not honestly expect that to work in a html/php output. Now for the second half, I have to figure out why I can't get the same display in TinyMCE.

Furqan Aziz Over a year ago

how you are outputting to tinymce ?

|

Collectives™ on Stack Overflow

How can I display a string output from mySQL with CakePHP?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related