remove </br> in MySQL

[enterume]

Hi,

How can I remove the </br> from the data I query from MySQL? But, I want to make in a new line when it is </br>.

Actually what I trying to do is, I want to use Javascript to update certain part in my page. so I will do something like below:

parent.document.getElementById('comment').childNodes[0].nodeValue = '<?=$data?>'

So if my $data contain </br>, i will get Javascript error message. Because the </br> will break down in new line when I echo it out. That's why i try to make my $data value is in a line.

Any idea?

Thanks
Louis

[Weedpacket]

Why would having </br> (</br>? What's that? Don't you mean <br/>?) in your echoed output break your Javascript string?

[enterume]

My case is like this:

1) I have a <textarea> for the user to key in their information($data), which may contain 'enter' for new line.

2) I use Javascript to update the information on my page without refresh the whole page. However, when i echo out the $data, it will split into few line for the 'enter' part.

3) I view souce and find that my $data is like this :

Line1</br>
Line2</br>
line3</br>
 

==> cause javascript error when I try to use javasript to display this $data.

I don't knwo where the </br> come from, may be is MySQL will convert the 'enter' to </br>.

Thanks
Louis

[nivlaC]

Use nl2br();.

[enterume]

do you mean i need to use this nl2br before insert into MySQL or when echo out the $data?

I tried to use nl2br() when echo out, but it will still show the $data in different line, which will cause the javascript error.

[nivlaC]

No, I'm sorry. Don't use that. Use this:

function convert_newlines($newline) {

$newline=str_replace("\r\n","\r\n",$newline);

return $newline;

}

That should work.

Use it before your query like this:

$variables = convert_newlines($variable);

HTH

[enterume]

Hi,

$newline=str_replace("\r\n","\r\n",$newline); 

?

May I know what is the purpose of replacing the '\r\n' , with as the same '\r\n', ?

THanks
Louis

[GSHelpBoy]

I had this problem myself.

I used this to resolve it:

<?php
$contents = str_replace("\n", "<br />", str_replace("\r", "", $contents));
?>

That adds the <br />, but strips out all line breaks.

[nivlaC]

Whoops! I meant:

$newline=str_replace("<br/>","\r\n",$newline);