Retrieving styled text from database

Level 29

To display this as html and not string you can use the v-html attribute

v-html="yourTextVariable"

For example

<p v-html="yourTextVariable"></p>

Level 1

ok so lets say the coding structure is like this:


<h1 v-html="TitleVariable"></h1>

<p v-html="paragraphVariable"></p> 

paragraphVariable = 
"
subtitle1

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, 

subtitle2

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, "

how do I retrieve subtitle1 and subtitle2 from the database while making sure they are of a bigger size or bold or underlined ??

Level 29

@john123 Do you use a richtexteditor to style the text before saving it to the database?

Level 1

@gych well to be honest I wanted to clear the logic of sending and retrieving styled text to and from the database before heading into the actual styling of the text, I would love it if you can give me pointers on what to use to style the text before saving it to the database too. sorry for bothering you and thanks for the help!!

Best Answer

Level 29

@john123 First you should look into adding a RichTextEditor that gives you the sytling options you need. There are multiple editors for this available with each their available styling options.

Personally I use SunEditor but there are also others like Quill Js, WYSIWYG Editor, CK Editor, TinyMCE, ... You should check multiple and see which one fits best to your needs and for your application.

When you've installed a RichTextEditor for you application you can use this as a kind of 'TextArea' in your form.

After the form has been saved to the database you can use the v-html attribute to display the styled text.

1 like

Level 1

@gych so if the datatype is nvarchar(MAX), the styled text is stored in it and can be retrieved without losing its style?

Level 29

@john123 Yes indeed, the output text from the richtexteditor is in HTML format which can be stored as a string in the DB. You can then display it as styled text by using the v-html attribute.

For larger texts you can use BLOB datatype in your DB (=binary in migration file)

1 like

Level 1

@gych I have been trying to figure out how to do it for a while thank you very much for your help!!!

1 like