Question

0

212

Views

MySQL varchar and linebreak only works on textarea

I've got a DB entry with a varchar field with the following text saved:

This is a line
new line here
and another line here

I can only see those line breaks if I print it within textarea. How can I make the line break work outside of textarea?

over 4 years ago · Santiago Trujillo

1 answers

Answer question

0

Answer question

Find remote jobs

Accepted Answer · 2022-05-26T17:00:21.742Z

A sequence of multiple white space characters is collapsed by default in HTML, except in some elements like textarea inner text like you noticed. You have a few options:

Process your text to convert newlines to <br> tags (see nl2br())
Echo it to an element which preserve line breaks, such as an styled <pre>
Use CSS to set the white-space of your element to pre, pre-line or pre-wrap which will respect line breaks

0

212

MySQL varchar and linebreak only works on textarea

1 answers

0

Find remote jobs

Andres GPT