When in debug mode, I hover over a variable that has a string in it I get a lot of:

Hello\r\n\t\tworld!\r\n

Which is annoying. This also shows up in the globals and locals panel.

Also I write my SQL like:

$sql = <<<EOT

SELECT *
FROM table
WHERE id=$id

EOT;

When I then hover over $sql to see if my SQL is ok I get a ton of \r\n\t\t\t and if I go to the local tab and copy the contents of $sql then past the SQL into SQLyog (A MySQL front end) I get:

\t\t\tSELECT *\r\n\t\t\tFROM table\r\n\t\t\tWHERE it=12

which is really annoying. Why is it doing that weird escape thing with the text? How can I fix it?

monk.e.boy

I wouldn't consider it an error, as it's showing you the contents of the variable which, in your case is full of those control characters.

What do you get when the variable is assigned in a more conventional manner...

you may change string representation format from PHP to text either in Locals popup or in Globals one.
While in php format, it will always show non-printed characters escaped.

Brilliant!!! Thank you soooooooo much!!!! This is ideal

monk.e.boy

I think you missed a couple smilies

perhaps, it's a good candidate for FAQ