Hello Jo�o,
On 15 Jan 2004 at 17:07, Jo�o C�ndido de Souza Neto wrote:
> I'm using str_replace("\r\n","\\r\\n",addslashes($campo)) to add "\" in
> mysql data to send to javascript variable.
>
> Running in my machine with win xp + iis it's all ok, but in server with
> linux + apache, the javascript variable no have "\" causing error in my
> script.
>
> Anybody know how do i do ?
(a) Have you tried mysql_escape_string() instead of addslashes() to escape your
string?
It will automatically escape line breaks and carriage returns as well as single and
double quotes and backslashes. Mind you, mysql_escape_string() can be used even if
your database is not MySQL.
(b) Have you considered that when you use double-quotes around a string (rather than
single-quotes) \r and \n get parsed and when you use single-quotes they don't? This
may have nothing to do with the problem you're experiencing and I may be saying
something stupid, but it might be worth looking into this issue.
Good luck,
Erik
