php/mysql help

ianhaney

on my website I have products and in the product description I am getting \n\r showing after each line where as it should be hiding it for example see below

16 ml in each bottle\r\nLuxury Style Bottles\r\nAvailable in White, Clear, Peach, Purple, Red, Pink and Black

it should be like below

16 ml in each bottle
Luxury Style Bottles
Available in White, Clear, Peach, Purple, Red, Pink and Black

Any ideas as not sure if it is the php file or the database causing the issue

To see the issue go here - http://www.worldofcosmetics.co.uk/product_info.php?cPath=28&products_id=169

Thank you in advance

Ian

bradgrafelman

If you view the raw contents of the DB before you do any processing on it, do you see those literal character sequences, e.g. a backslash followed by the letter 'r', etc.?

If so, then it sounds like the issue is the data was corrupted before it was inserted into your DB. Rather than actual line break characters being inserted, you instead inserted those escape sequences. Perhaps the data was doubly escaped, e.g. you've got the dreaded magic_quotes_gpc enabled and later sanitized the data?

You'll probably want to investigate how this happened in the first place and make sure that issue gets resolved. For the display issue at hand, you should probably "clean up" your DB by replacing those '\r\n' sequences with actual line break characters.

(Of course, a secondary issue might then pop up; namely, line breaks in HTML markup don't result in line breaks displayed on the page - you have to insert <br> entities for that to happen.)