mysqli::real_escape_string creates \r\n problems?

mysqli::real_escape_string creates \r\n problems?



1.PHP: mysql_real_escape_string - Manual

Description:mysql_real_escape_string (PHP 4 >= 4.3.0, PHP 5)
mysql_real_escape_string — Escapes special characters in a string for use
in an SQL statement



2.mysql_real_escape_string() /r/n problems - CodingForums.com

Description:mysql_real_escape_string() /r/n problems PHP ... Hey I'm
wondering if anyone knows a way around the mysql_real_escape_string()
problem that adds /r/n to line breaks.



3.PHP: mysqli::real_escape_string - Manual

Description:mysqli::real_escape_string ... This function is used to create
a legal SQL string that you can use in an SQL statement. ... (ASCII 0),
\n, \r, \, ', ", and Control-Z.



4.MySQL :: MySQL 5.0 Reference Manual :: 20.6.7.53 mysql_real ...

Description:unsigned long mysql_real_escape_string(MYSQL *mysql, char *to,
const char *from, unsigned long length) Note that mysql must be a valid,
open connection.



5.PHP mysqli_real_escape_string() Function

Description:Definition and Usage. The mysqli_real_escape_string() function
escapes special characters in a string for use in an SQL statement.



6.PHP: mysqli::real_escape_string - Manual

Description:mysqli::real_escape_string ... (ASCII 0), \n, \r, \, ', ", and
Control-Z. ... $mysqli-> query ("CREATE TEMPORARY TABLE myCity LIKE
City");



7.mysqli_real_escape_string

Description:string mysqli_real_escape_string ... This function is used to
create a legal SQL string that you can use in a SQL statement. ... (ASCII
0), \n, \r, \, ', ", and ...



8.PHP tutorial: mysql-real-escape-string function

Description:mysql_real_escape_string (PHP 4 >= 4.3.0, PHP 5)
mysql_real_escape_string — Escapes special characters in a string for use
in an SQL statement



9.PHP tutorial: mysqli.real-escape-string

Description:PHP tutorial: mysqli.real-escape-string ... This function is
used to create a legal SQL string that you can use in an SQL statement.



10.PHP Manual: mysqli_real_escape_string

Description:string mysqli_real_escape_string ... This function is used to
create a legal SQL string that you can use in a SQL ... \n, \r, \, ', ",
and Control-Z. Return ...