Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Inserted entry from MCE editor is not rendering HTML on query...

Posted on 2013-12-13
10
Medium Priority
?
326 Views
Last Modified: 2013-12-21
I'm using MCE editor and the entry in the db for each post is something like...

&ltp&gtLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque placerat risus lacus, eu mollis lorem venenatis ut. Donec imperdiet turpis elit. Suspendisse lobortis commodo elit, et laoreet elit.&lt/p&gt

when I <cfoutput> the result to the front-end I get <p>Lorem ipsum.... </p>

Open in new window


I would like for it to actually render the value as HTML
0
Comment
Question by:brihol44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 25

Expert Comment

by:dgrafx
ID: 39718863
i'm guessing you mean that you want to show the html entities that are in the db instead of the browser converting them to tags or symbols - correct?

use:
<pre><code>
&ltp&gtLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque placerat risus lacus, eu mollis lorem venenatis ut. Donec imperdiet turpis elit. Suspendisse lobortis commodo elit, et laoreet elit.&lt/p&gt
</code></pre>
0
 

Author Comment

by:brihol44
ID: 39718882
Well, I want them to actually render as HTML so I dont' see <p>  tag or any reference to it. I'm not sure why it's not actually adding it as HTML but instead showing it on the page. I suppose I have to figure out how it's getting in the db first? The MCE editor automatically adds the <p> tags in the entry but it's converting to &ltp&g when it posts the entry to the db.

Thanks for the help!
0
 
LVL 25

Expert Comment

by:dgrafx
ID: 39718955
You do mean inside the editor - correct?
Are you viewing html source?
Just checking.

Are you saying that when you insert <p> into the db - then when you look in the db it has been converted to &lt;p&gt ?

if yes then what init settings do you have in mce editor for entity_encoding?
And also are there settings for MySql concerning this?
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:brihol44
ID: 39719077
Hi,

Well it's showing the "<p>" tag actually on the website (dev) on the front page that people see.

Inside the editor it shows correctly in that I only see text. When I click on the "HTML" view button it's...

<p>Loren ipsum.... </p>

My Table info is...

Table Type MyISAM
Default Char Set : utf8
Default Collation: utf8_general_ci


entity encoding :
entity_encoding : 'named',
0
 

Author Comment

by:brihol44
ID: 39719079
oh and...

Are you saying that when you insert <p> into the db - then when you look in the db it has been converted to &lt;p&gt ?
No MCE actually inserts the <p> tag automatically which is fine. My only issue is that it's showing <p>Loren ipsum... </p> that is displaying on the front-end.

The entry in the db is...  &ltp&gtLorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur dapibus, turpis vitae congue hendrerit, purus libero semper turpis, quis egestas tellus augue a odio.&lt/p&gt
0
 
LVL 25

Expert Comment

by:dgrafx
ID: 39719110
For experimentation's sake manually edit the db and replace the &lt;p&gt with <p> and the same for closing.
Then look at the webpage.

does the problem go away or is it the same issue?
0
 

Author Comment

by:brihol44
ID: 39719184
Doing that does work so I guess I have to figure out why MCE is converting the <p> tag to &lt;p&gt. I don't know much about the editor so I'm not too sure yet.
0
 
LVL 25

Accepted Solution

by:
dgrafx earned 880 total points
ID: 39719188
in your tinymce init - do you have an entry for entity_encoding?
set it's value to raw if yes or add it if you don't so that it's:
entity_encoding:"raw"

that might help.
0
 

Author Closing Comment

by:brihol44
ID: 39733992
I ended up using coldfusion to replace the arrow values. I tried all of the things you had mentioned. I'm not sure what's going on with it.
0
 
LVL 25

Expert Comment

by:dgrafx
ID: 39734110
well - thanks for the points!

and i hope you get it squared away!
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question