php echo from database with break lines

Question

This is a simple question I believe, but can't figure it out yet. I have a text area that after submit goes to a database, and then I echo this text on a page, but here is the problem, say the person writes on the textarea:

Hi Robert,
This is just a test!.
Jason.

And the message goes to the database just like that, but when I echo that, I get:

Hi Robert, This is just a test!. Jason.

This is the form:

<textarea name="newMessage" wrap="hard" cols="30" rows="3"></textarea>

<input type="submit" name="submit" value="Ingresar"> </>

This is the code I use to display the text:

<?php   
    while($row = mysql_fetch_assoc($messages)){
        echo $row['mensaje']."<br/>";
    }
?>

This is what I use to insert the code:

if(isset($_POST['submit'])){        

            $check4LB = $_POST['newMessage'];
            while($letter = mysql_fetch_assoc($check4LB)){
                if($letter=' '){
                $letter='<br/>';
                }
            } /////I know this is not write bu is the idea i thgouht at least

            $query = mysql_query("SELECT (ifnull(max(idRegistro),0) + 1) as id FROM messages");
            $row = mysql_fetch_array($query);
            $idMax = $row['id'];     
            $insertMessage = "INSERT INTO messages(idRegistro, mensaje) VALUES ('".$idMax."','".$letter."')";

             mysql_query($insertMessage) or die(mysql_error());
             echo "<meta http-equiv=Refresh content=\"0 ; url=".$_SERVER['PHP_SELF']."\">"; 
   }

@JapanPro It's better to save data as is and format it only when you want to display it. — ariefbayu
– ariefbayu, Commented Apr 20, 2011 at 2:32

Sabeen Malik · Accepted Answer · 2011-04-20 02:13:12Z

18

try echo nl2br($row['mensaje']);

answered Apr 20, 2011 at 2:13

Sabeen Malik

10.9k4 gold badges37 silver badges51 bronze badges

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

1 Comment

Pankaj katiyar Over a year ago

here nl2br($row['stackoverflow_comment_text']); not working

Ry- · Accepted Answer · 2011-04-20 02:13:29Z

2

Use nl2br() on the output from the database.

answered Apr 20, 2011 at 2:13

Ry-♦

226k56 gold badges496 silver badges504 bronze badges

Comments

Pramendra Gupta · Accepted Answer · 2011-04-20 02:20:02Z

0

Try this

<?php   
    while($row = mysql_fetch_assoc($messages)){
     echo str_replace("\r",'<br/>',$row['mensaje']); 
    }
?>

answered Apr 20, 2011 at 2:20

Pramendra Gupta

14.9k4 gold badges35 silver badges35 bronze badges

1 Comment

ariefbayu Over a year ago

There are 3 type of newline: \r on mac, \n on linux/unix, \r\n windows. So, it's better to use nl2br() which handle the difference.

Collectives™ on Stack Overflow

php echo from database with break lines

3 Answers 3

1 Comment

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Related