Forms and MySQL

[palpie]

I have a form with a textbox in. What is typed there is after submission stored in a MySQL database.

When you type something it is stored as it should. Enter strokes is also stored. But it not stored as any letter or anything like that.

When I later list the content of the database the linefeed can be seen in the code.

What I would like to do is to change all those linefeeds to "<BR>". Is it an esc character or something?

How can I do this?

[brandonschnell]

yes, using the php function nl2br().

http://www.php.net/nl2br

[Anon]

Thanks! Damn, I've been looking at that function before, but now when I needed it I forgot about it :/

But, thanks again 🙂

[palpie]

I have used nl2br on a string. It returns in the code, for example:

This is some text...
<br>

<br>
... and this too.

I would like to change it so it looks like:

This is some text...
<BR><BR>
... and this too.

How can I do this? I've tried with str_replace. Maybe I've done wrong. Maybe I should use another function.