Html in my database!

Question

I came across something that I don’t know where to start.

I currently have a news section on my website, news is being added to the database. However, it is very boring and has no formatting!

How can I let the administrator add news to make it bold or underlined, as well as have color, etc. Is it possible to save this in the database as usual.

Sorry if this is a really stupid question, but this is something that I have not come across before!

thank

Answer 1

HTML , HTML, , , .

( , HTML , script -injection), : <div> , .

HTML- HTML- "", . , . , , , . *italic*, **bold**, http:​//www.example.com/ → italic, , http://www.example.com/.

. , , Markdown.

(Markdown , , HTML- , , , `-quotes. , : bbcode, reST, Textile ..)

Answer 2

CKEditor , , html. CKEditor . , HTML.

Answer 3

:

INSERT INTO tbl (html_text) values ('<h1>Hello, world.</h1>')

(, .)

Answer 4

HTML, varchar (max), , HTML, (.. -). , , HTML.

Answer 5

You can use any number of text editors to provide text formatting functionality. Then you can save this to the database just like regular text.

Just make sure HTML encodes your output.

I prefer CKEditor for my rich text editor. Very reliable, mature and cross platform.