Help correcting CR LF issue

Tea_J

Hi guys

I have this problem w/ CR LF entities w/ my forms.. here's an example to keep things short and simple...

I have 2 forms, where they are identical,
1 is done in FLASH
the other in HTML

These forms have plain text multiline text area..

i typed

1
2

the data from these forms are directly inserted into MySQL upon submission..

here's the problem

using Navicat MySQL manager (or other Win32 mysql managers), there is a one-liner ROW PREVIEW(where u see the data partially, and MEMO VIEW (where in you see the whole text content of that particular row).. using this i can see that:

1) the data from HTML is PERFECT where linebreaks appear as , well, invisible in the ROW PREVIEW preview, and the MEMO VIEW shows the text are each in 1 line

2) the data from FLASH however shows these SQUARE SYMBOLS inplace of where the line breaks should be in,
http://img267.imageshack.us/img267/8111/rowpreviewsquaresymbols.jpg

but in the MEMO VIEW the text are OK and in separate line each

Now this is the source of all my display problems (wont go into details anymore but i already know this is where the problem is)

I copy pasted both in my advanced notepad and they seem to be identical in nature

1CR LF
2

(where the CR LF chars are in black inverted background = special characters..

So now im pretty stuck here.. tried playing w/ str_replace .. dont really know w/c character to target.. dont wana deal w/ regex though if i have other solutions, to keep my script fast.. (regex slows things down and w/ this particular script going to be doing about 2000 loops at least )

Would really love some help

Regards
TJ

Krik

You need to remove or replace all \r and \n these are hidden special characters that are inserted when the user hits the enter/return key. The "CR LF" is actually "\r\n"

Here is piece of code I use any time I have to store user input data in a database

$order = array("\r\n", "\n", "\r");
$replace = ' ';
$text = str_replace($order, $replace, $text);

Of course the value of "$replace" can vary depending on my end goal with the data.

You can also use [man]nl2br[/man]