I've looked throughphpmyadmins code and found these
str_replace('\r', "\015", $value);
str_replace('\n', "\012", $value);
str_replace('\t', "\011", $value);
But none of them worked. I also tried
str_replace('
', '\n\r', $value);
But this was also unsuccessful. What I'm trying to do is format multilined sql dumps to a single line so they can easily be divided into an array and queried back but I can't seem to get rid of the line breaks which I want to preserve along the way (for readability of html kept in the db).
Any ideas?