What are the functions for php mysql to escape special characters?

php mysql function to escape special characters

Function one is mysql_escape_string, function two is addslashes.

And addslashes Convert "'" to """ when magic_quotes_sybase=on

Convert "'" to "'" when magic_quotes_sybase=off PHP provides some functions to make the query statement meet the requirements. For example, mysql_escape_string references a string and returns a result, which can be used as an appropriately escaped data value in an SQL statement. The string is returned surrounded by single quotes, and every occurrence of a single quote ("'"), backslash (""), ASCII NUL, and Control-Z in the string is preceded by that character. Add a backslash. If the argument is NULL, the result value is the word "NULL" without single quotes. The QUOTE function was added in MySQL 4.0.3. Recommended reading: php character escape function reference, php regular expression escape character examples, I hope it can help everyone understand how to handle escape characters and special characters in PHP programming.

When writing data to the database, sometimes the string to be written contains some special characters, such as ',",/,%, etc. I don't know if MySQL itself has such an escaping function, not those APIs .