[RESOLVED] Need some help cleaning up my stored info

[Dolemite50]

Hi,

I think this q lies somewhere between database and general PHP so I'll take a shot in this section.

As a rookie I struggled to find the right combination of addslashes/stripslashes/html enemities,..etc when prepping text for the database. I'm now using mysql_escape_string and all seems to work great, but the data stored using the old method is chuck full of artifacts. Here is an example:

This isn\\'t the third line.\r\n\r\nThis is the third line.

I now want to go through all of the data and clean it up but I don't know the right way to go about it. For example, how would I replace "\r\n" with a carriage return so that the above shows in the database as:

This isn't the third line.

This is the third line.

Thanks for any help.

[laserlight]

For example, how would I replace "\r\n" with a carriage return

It looks like you want to use [man]stripcslashes/man. I do wonder how you managed to manhandle the new line sequences since addcslashes() requires some doing, and addslashes() and htmlentities() should not touch new line sequences.

[Dolemite50]

Hi Laser,

Thanks alot for the tip. I have no idea how I ended up with what I did because I just kept adding and removing functions until everything worked. I'm ashamed to tell you that somehow it arose from me butchering your prepIn prepOut functions that you posted a few years back. :o

Thanks again!