How to display data with line breaks from MySQL in PHP

Question

I am storing user inputs in my DB unencoded, this includes line breaks in the data. There are no \n or <br>'s in the inputs when then displaying the data again so the line breaks are lost.

I have tried wrapping the output in htmlspecialchars but it has not made a difference.

How can I accurately display this content?

Anonymous · Accepted Answer · 2014-03-23 01:44:43Z

8

You can use nl2br():

$data = nl2br($data);

This adds HTML line breaks <br> before PHP line breaks \n.

answered Mar 23, 2014 at 1:44

Anonymous

12.1k7 gold badges37 silver badges58 bronze badges

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

Comments

Vicky Mahale · Accepted Answer · 2017-11-13 07:00:21Z

0

You Can also Used this. PHP generates HTML. You may want:

echo "foo";
echo "<br />\n";
echo "bar";

I think, It is used full to you.

Thank You..

answered Nov 13, 2017 at 7:00

Vicky Mahale

1,2291 gold badge12 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to display data with line breaks from MySQL in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related