How do I match linebreak stored in MySQL db?

bunner_bob

Here's the problem: I'm emailing the contents of a couple of fields (confirmation email for a signup system). In those fields, two returns (entered as returns in a web form before submitting to the db) are translating into four returns in the email message content.

What I want to do is find and replace doubles of whatever these are with singles (giving me two returns). But try as I might I can't seem to match them - I've tried:

strstr($field, '<br /><br />');

strstr($field, '<br><br>');

strstr($field, '/n/n');

strstr($field, '/r/r');

strstr($field, '/n/r');

strstr($field, '/r/n');

and none of these seem to match. I'm sure it's just a matter of my syntax - need double quotes, multiple backslashes, something like that. Can someone clue me in as to how to match linebreaks in a mysql result field?

laserlight

The new line sequences are:

Unix: "\n"
DOS/Windows: "\r\n"
Mac: "\r"

bunner_bob

Are those based on the machine on which the data is entered, or the machine on which PHP/MySQL is running?

Turns out what's being stored in the db is "\r\n", which is odd because I'm working on a Mac (OS X), and the site is hosted on a Linux box. Is something somehow combining the two?

Anyway, seem to have gotten it working - thanks!

nemonoman

I have had this problem and this is my kluge:

function justdoreturns($string){
$string=str_replace(chr(10), 'fixmepleasearandomstring',$string);
$string=str_replace('fixmepleasearandomstring'.chr(13),chr(13), $string);
/* I don't think chr(13).chr(10) exists, but let's fix it anyway' */
$string=str_replace(chr(13).'fixmepleasearandomstring',chr(13),$string); 
$string=str_replace('fixmepleasearandomstring',chr(13), $string);
return $string;
}

Remember that email programs may be compounding this effect: changing everything to single cr's will fix the problem.

The function above will NOT affect multilple line breaks:

$string=" this

is my string";

will stay like that before and after the function.