How to output mysql multiline data in the same format with PHP and HTML?

Question

I just started learning how to make a website. I'm making a comment box which is used to enter blog entries. Let's say I types in an entry with 3 lines, and it will show up the same format in mySQL table. But when i try to output it, it becomes one line.

//Here's what i did to output the data.
$entry = $row['entry'];
echo "<p>". $entry ."</p>";

//INPUT
Hello,
TEST LINE2
TEST LINE3

//OUTPUT
Hello, TEST LINE2 TEST LINE3

If you start lerning try to use mysqli in youre web-sites

Igor Konopko
– Igor Konopko

2012-05-19 18:19:19 +00:00
Commented May 19, 2012 at 18:19 — Igor Konopko
– Igor Konopko, Commented May 19, 2012 at 18:19

josmith · Accepted Answer · 2012-05-19 18:11:37Z

5

You could use http://php.net/manual/en/function.nl2br.php

"Inserts HTML line breaks before all newlines in a string"

$entry = $row['entry'];
echo "<p>". nl2br($entry) ."</p>";

answered May 19, 2012 at 18:11

josmith

1,0497 silver badges17 bronze badges

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

Comments

Musa · Accepted Answer · 2012-05-19 17:59:29Z

2

Wrap it in a pre tag, this will prevent white spaces from breaking.

$entry = $row['entry'];
echo "<p><pre>". $entry ."</pre></p>";

answered May 19, 2012 at 17:59

Musa

97.9k17 gold badges123 silver badges144 bronze badges

2 Comments

Musa Over a year ago

@ylhtravis what css are you using?

Matthew Over a year ago

You can style the <pre> tag with CSS as well.

phsaires · Accepted Answer · 2012-05-19 20:11:55Z

0

$entry = $row['entry'];
echo $entry ."<br />";

Or

$entry = $row['entry'];
echo $entry ."<br>";

answered May 19, 2012 at 20:11

phsaires

2,4281 gold badge16 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to output mysql multiline data in the same format with PHP and HTML?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related