[SOLVED] Handling mid-line carriage returns in a flatfile database?

[Schlo_50]

Hello,

 

I'm using a flat file database and getting problems when carriage returns occur in the middle of lines. This happens, for example, when the text comes from a web form TEXTAREA field.

 

How can I strip and replace such carriage return characters with the word [break] and keep everything on one line/row?

 

The following code replaces \n with [break] but when I view the datebase everything is still on a new line  ???.

$input = str_replace("\n", "[break]", $_POST[$key]);

 

Any help with this would be great!

Thanks

[Mchl]

You should also replace \r and \r\n

[Schlo_50]

Wicked.

 

I used:

 

$input = str_replace("\r\n", "[break]", $_POST[$key]);

 

Thanks!

[Mchl]

Use

$input = str_replace(array("\r\n","\r","\n"), "[break]", $_POST[$key]);

 

If you're interested in why it's so wicked, read this