Store HTML from Java in to MYSQL Database

Question

I am trying to store some HTML created by users with TinyMCE .I am using JQuery AJAX POST to post content to other page . What happens is HTML is having   or & than it treats content after that as a new parameter so only content before that '&' is stored to database.Do I have to escape it before posting ?If so how ?

duffymo · Accepted Answer · 2011-04-21 15:22:22Z

1

I would never save HTML in a database. HTML is presentation; relational databases are for persistence. Save the data and format it as HTML. Keep the two layers separate.

answered Apr 21, 2011 at 15:22

duffymo

310k46 gold badges376 silver badges570 bronze badges

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

2 Comments

Pit Digger Over a year ago

What if there is some application where user can have their own htm content?There is no predefined template in this case.

DarthJDG Over a year ago

Wordpress or any other CMS? It is quite justified in certain situations.

Eric Frick · Accepted Answer · 2011-04-21 15:25:19Z

0

the data must be stored in a database and the layout (html) in a webform or related. Retrieve the data when needed and add the html code in the page itself

answered Apr 21, 2011 at 15:25

Eric Frick

8572 gold badges7 silver badges18 bronze badges

Comments

Pit Digger · Accepted Answer · 2011-04-21 16:10:13Z

0

Whoopse .... escape() worked for me .

answered Apr 21, 2011 at 16:10

Pit Digger

9,83023 gold badges81 silver badges126 bronze badges

Collectives™ on Stack Overflow

Store HTML from Java in to MYSQL Database

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related