how mysql_real_escape_string work

Question

How does mysql_real_escape_string work? Does it delete mysql functions or add // between mysql function? Is it better than addslashes

Answer 1

mysql_real_escape_string() calls MySQL's library function mysql_real_escape_string, which prepends backslashes to the following characters: \x00, \n, \r, \, ', " and \x1a.

This function must always (with few exceptions) be used to make data safe before sending a query to MySQL.

IMO, its better to use this function than attempting to recreate, most of the time.