How to View New Lines in Database Fields

[Antony]

If you have a database field with new line characters in it (rather than <br> or <p>), the new lines are ignored if you display the database field using this form:

<p>{{field_name}}</p>

This will show:

Line 1 Line 2 Line 3

But they are shown if you display the database field using this form:

<p dmx-text="field_name"></p>

This will show:

Line 1 
Line 2 
LIne 3

[Teodor]

If you have html code stored in your database table and you want to use it on the page then you need to use the Inner HTML attribute.

[Antony]

Indeed!

In my example, the content in the database was created using a textarea element which inserts new line characters, rather than a summernote element which inserts <br> and <p>.

[Teodor]

So what is your question here exactly? Is it not working with Inner HTML or is your issue something else?

[Antony]

There is no question. This is the answer to a problem I just had!

I created database content with a textarea and then tried to display it with <p>{{field_name}}</p> and the new lines were missing…

So the answer I discovered is here for everyone else to find…

[Teodor]

You posted this in the how to section, which is used to ask how to … do some stuff. So i thought you have problems doing what you were trying to do…
And as i explained the purpose of Inner HTML is exactly this.

[Antony]

@Teodor

You posted this in the how to section

Yes, this is the answer about "How To" do something!

[Teodor]

Sorry Antony, i just probably don’t understand the point of this topic. Hope others will.

[Antony]

@Teodor

Hope others will

I am sure they will!

The point is if you create database content with a textarea and then try to display it with <p>{{field_name}}</p> then the new line characters will not be displayed!

[Teodor]

@Antony

with <p>{{field_name}}</p> then the new line characters will not be displayed!

Of course they won't be displayed Antony!
That is why we have created a special dynamic attribute called Inner HTML which will render your HTML on the page ...

[Antony]

@Teodor

Of course they won’t be displayed Antony!

Well it may be "Of course" to you, but it wasn't "Of course" to me in the moment I worked on my code...

and now if it isn't "Of course" to others then they can read my post.

We all have different levels of knowledge @Teodor...

... and since Wappler is a tool that requires you to have less knowledge than before, my post is here to help others like me!

[Teodor]

Textearea format in the database with html elements

when I submit the textarea field in the database, I still have the html elements - paragraph line-break etc. And When I try to display the content as dynamic on the page, it shows the html element without any format. Is there any way to display the message without seeing these elements but having the format. Thank you

HTML showing in the visual display of the page

Hi I have a database field that contains information with HTML tags. When I bind the data it is displayed on the page with the HTML tags, however, I want it to be displayed using those tags to style the elements within the record. How can I do this? Thanks again for you help.

HTML - Formating data in dynamic tables

Hi, I found how to format strings, numbers, … in dynamic tables. But if I have a text containing HTML code it will show the HTML tags in the cell. I discovered how to strip the tags , but I really want to show the HTML-formatted text in the cell. For example: This is a <b>bold</b> text. is shown with the < b > tag. But I want to display: This is a bold text. Any hint, how to realise this? Thank you!

Output HTML directly from database

I am looking to have a database full of events and each record has a field containing the HTML from a PayPal Buy Now button. I want to show the info about the event and then show the Buy Now button dynamically but when I add it to the page, the raw HTML is shown instead. Is there a way of outputting it so the button displays correctly?

just a few of all the topics asking the same question.