\n does not work?

[neo777ph]

help.

 

I would like to echo:

<? echo "test\n" . "test2"; ?>

as far as i know the output should be:

test

test2

 

i switched the auto_detect_line_endings into ON..to fix the problem..But it still does not fix the problem..I need the new line for my logging system.

 

please help me.

[ashly]

Use :

<? echo "test<br>" . "test2"; ?>

[neo777ph]

i did that already..

ok to be more straight.. =>

 

thus <br> be interpreted by a field on my MY_sql db as a new lineb \n..

So when it is inserted in the database..

 

it would be:

test

test2

[JasonLewis]

use the nl2br() function to change the strings \n to the br tag. here is an example.

 

$string = "This is a string with a \n newline in it."; //newline string.
$string = nl2br($string);

echo $string; //The string will now be properly formatted

[neo777ph]

thx for the nl2br()..

 

just want to confirm would \n be interpreted by my_sql as new line..So when it is inserted on the field..

 

it would be..

 

example: $test = "test \n test2";

the database field would take it as :

test

test2

[JasonLewis]

yes, as far as i know mysql inserts new line data as a new line.

[btherl]

To be safe, I would use mysql_real_escape_string() before inserting the data to mysql.  Then you can be sure that ANY character will be correctly stored (any that is supported by the underlying data type that is.  Binary data will need mysql's binary data type, which I forgot the name of.  But \n is still ok for text/varchar data).

[ToonMariner]

This depends on your OS - *nix uses \n (I think) Windows uses \r\n

[Jenk]

This depends on your OS - *nix uses \n (I think) Windows uses \r\n

It depends on your choice of encoding to be more precise.

[wildteen88]

no mater what  OS you use MySQL will store the the newline. It just when you send newline charactersw (\r\n, \r or \n) to a web browser it will just ignore them - They are still there but can only be viewed from source. In order to get the browser to display them you need to use the HTML line breaks (<br />).

 

It best to use nl2br when getting data out of the database, not when inserting it into the database.