mysql & php new line problem

[Mattias]

I started learning php and mysql to create dynamic pages with a admin interface. I created it with the textarea tag and put the text into mysql and it looks like this when i see it in phpmyadmin

This is a test
this is line 2
this is line 3

but when outputting in php i get it all in the same row.
i fetch the text from mysql and put it into a variable. somewhere along the line the new lines or linefeeds dissepear,
does anyone have an awnser, i use php5 and mysql5

thanx in advance/ Mattias

[vinyl-junkie]

Hi, Mattias, and welcome to the forum!

The reason you're getting that is there are hidden new line characters "/n" (without the quotes) embedded in your text. To get rid of them and have your text display correctly in an HTML document, you need to use str_replace. For example:

$line = str_replace("\n","\n<br>","$line"); 

Hope this helps.

[Mattias]

Hi.
Thanks!
It worked great.

[tomas155]

And how will be if i want the output like

echo "<a href='....' title='$line'>....</a>"; 

[jthayne]

$line = str_replace("\n","\n<br>","$line"); 

You can also use nl2br for this:

echo nl2br($line); 

And how will be if i want the output like

echo "<a href='....' title='$line'>....</a>"; 

Use the str_replace that vinyl_junkie mentioned before. Then you won't have to worry about the line breaks in the anchor title.

$line = str_replace("\n", "", $line); 

[ellias]

Firstly I would like to suggest you to learn the PHP codes first. Then you do not face such kind of problem. some of the code of php is different then html. So I would like to suggest you to learn the codes from some good tutorial like w3schools.

[jthayne]

some of the code of php is different then html.

That statement has always bugged me. PHP and HTML are two completely different things. ALL of PHP code is different from HTML. HTML does only one thing: displays and formats data. It does not interpret the data nor do anything with servers. PHP on the other hand, gets the data from its source, determines what should happen with the data, and then creates the HTML code to display it.

So I would like to suggest you to learn the codes from some good tutorial like w3schools.

This is always good advice. I still use the tutorials as reference at times.