What does mysql_real_escape_string() do that addslashes() doesn’t?

by

It adds slashes to: 

\x00, \n, \r, \, ', " and \x1a. characters.

Where addslashes only adds slashes to 

' \ and NUL

Ilias article is also pretty detailed on its functionality

More Related Contents:

  1. How can I prevent SQL injection in PHP?
  2. SQL injection that gets around mysql_real_escape_string()
  3. How can I sanitize user input with PHP?
  4. Are PDO prepared statements sufficient to prevent SQL injection?
  5. Is “mysqli_real_escape_string” enough to avoid SQL injection or other SQL attacks?
  6. Reference: What is a perfect code sample using the MySQL extension? [closed]
  7. The ultimate clean/secure function
  8. Do htmlspecialchars and mysql_real_escape_string keep my PHP code safe from injection?
  9. When should I use prepared statements?
  10. Examples of SQL Injections through addslashes()?
  11. SQL injections in ADOdb and general website security
  12. Why is using a mysql prepared statement more secure than using the common escape functions?
  13. how safe are PDO prepared statements
  14. Is htmlspecialchars enough to prevent an SQL injection on a variable enclosed in single quotes?
  15. How do I use password hashing with PDO to make my code more secure? [closed]
  16. PHP: Is mysql_real_escape_string sufficient for cleaning user input?
  17. PHP image upload security check list
  18. Many hash iterations: append salt every time?
  19. PHP: How To Disable Dangerous Functions
  20. How to prevent multiple logins in PHP website
  21. What security issues should I look out for in PHP
  22. Detecting Ajax in PHP and making sure request was from my own website
  23. Generate cryptographically secure random numbers in php
  24. Is mysqli_real_escape_string safe?
  25. Use of Initialization Vector in openssl_encrypt
  26. Secure User Image Upload Capabilities in PHP
  27. Set httpOnly and secure on PHPSESSID cookie in PHP
  28. Does PHP’s $_REQUEST method have a security problem?
  29. Json: PHP to JavaScript safe or not?
  30. What encryption algorithm is best for encrypting cookies?

Leave a Comment