brihol44
asked on
Inserted entry from MCE editor is not rendering HTML on query...
I'm using MCE editor and the entry in the db for each post is something like...
I would like for it to actually render the value as HTML
<p>Lorem 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.</p>
when I <cfoutput> the result to the front-end I get <p>Lorem ipsum.... </p>
I would like for it to actually render the value as HTML
ASKER
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 <p&g when it posts the entry to the db.
Thanks for the help!
Thanks for the help!
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 <p> ?
if yes then what init settings do you have in mce editor for entity_encoding?
And also are there settings for MySql concerning this?
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 <p> ?
if yes then what init settings do you have in mce editor for entity_encoding?
And also are there settings for MySql concerning this?
ASKER
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',
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',
ASKER
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 <p> ? 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... <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur dapibus, turpis vitae congue hendrerit, purus libero semper turpis, quis egestas tellus augue a odio.</p>
Are you saying that when you insert <p> into the db - then when you look in the db it has been converted to <p> ? 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... <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur dapibus, turpis vitae congue hendrerit, purus libero semper turpis, quis egestas tellus augue a odio.</p>
For experimentation's sake manually edit the db and replace the <p> with <p> and the same for closing.
Then look at the webpage.
does the problem go away or is it the same issue?
Then look at the webpage.
does the problem go away or is it the same issue?
ASKER
Doing that does work so I guess I have to figure out why MCE is converting the <p> tag to <p>. I don't know much about the editor so I'm not too sure yet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
well - thanks for the points!
and i hope you get it squared away!
and i hope you get it squared away!
use:
<pre><code>
<p>Lorem 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.</p>
</code></pre>