PHP MYSQL fetching a TEXT with new lines

Question

<?php

//after connecting etc..
        $username = $_SESSION['username'];
        $string = "SELECT msg FROM $table WHERE username='$username'";
    $result = mysql_fetch_array(mysql_query($string)) or die(mysql_error());
    echo $result[msg];
?>

this is how the database is..

I wanted to install the database base.
I wanted to install the database server.
I wanted to install the Ubuntu.

when i retrieve them they appear as..

I wanted to install the database base.I wanted to install the database server.I wanted to install the Ubuntu.

Its a TEXT field.. is there a way to make them appear with the new lines? exactly the same?

Thanks a lot!

try echo "<pre>".$result[msg]."</pre>"; to check do newlines appear in code (or just take a look of output source). If does, convert newlines to <br /> (nl2br function) and use it inside your html document. — Wh1T3h4Ck5
– Wh1T3h4Ck5, Commented Jul 10, 2011 at 4:31

zerkms · Accepted Answer · 2011-07-10 04:30:41Z

14

Use this:

echo nl2br($result[msg]);

As long as browsers doesn't treat \r\n as real new-lines - you need to "convert" them to <br>'s with nl2br()

answered Jul 10, 2011 at 4:30

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

Comments

user350034 · Accepted Answer · 2011-07-10 04:31:03Z

7

Maybe nl2br is what are you looking for?

answered Jul 10, 2011 at 4:31

user350034

Comments

Roberh · Accepted Answer · 2020-10-31 10:47:49Z

1

Also you can use:
REPLACE(`col_name`,"\n","<br />") as `col_name`
You must use this after SELECT.

Example code:
SELECT *, REPLACE(`name`,"\n","<br />") as `name` FROM xyz WHERE id="%s"

answered Oct 31, 2020 at 10:47

Roberh

234 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL fetching a TEXT with new lines

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related