mysql_real_escape_string is undefined

by

Update as mentioned in comment, mysql_ has been deprecated since 5.5:

The mysql extension has been deprecated since PHP 5.5. The mysqli or PDO extension should be used instead. The deprecation has been decided in mysql_deprecation, where a discussion of the reasons behind this decision can be found.

and removed in PHP 7.

mysql_real_escape_string() is standard part of MySQL function “batch” and should always work if the extension is loaded correctly.

Does any another mysql_ function work? (It should not)

Make sure, that you have this line uncommented in your php.ini:

extension=mysql.so

Also it’d be wise to use mysqli or PDO instead (mysql_ is deprecated), they both can take care of escaping for you.

More Related Contents:

  1. Undefined function mysql_connect()
  2. PHP 7 RC3: How to install missing MySQL PDO
  3. How to get MySql 8 to run with laravel? [duplicate]
  4. recurring system my sql query [closed]
  5. MySQL query won't update database [closed]
  6. Cannot modify header information [duplicate]
  7. Gather column name of a table from database [closed]
  8. PHP sending form data to the database
  9. Insert form in MySQL with PDO [duplicate]
  10. Is the following code valid? [closed]
  11. How do I get the last inserted ID of a MySQL table in PHP?
  12. Getting raw SQL query string from PDO prepared statements
  13. SET NAMES utf8 in MySQL?
  14. How to get count of rows in MySQL table using PHP?
  15. “Invalid parameter number: parameter was not defined” Inserting data
  16. MySQL Prepared statements with a variable size variable list
  17. Using Jquery Ajax to retrieve data from Mysql
  18. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  19. How can I enable the MySQLi extension in PHP 7?
  20. PHP, MySQL error: Column count doesn’t match value count at row 1
  21. MySQL server has gone away – in exactly 60 seconds
  22. displaying an image stored in a mysql blob
  23. Why is password_verify returning false?
  24. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  25. Laravel OrderBy relationship count
  26. Dynamic table in HTML using MySQL and php
  27. How can I debug why simplest MySQL query returns false?
  28. PHP to MySQL SSL Connections
  29. Backup a mysql database and download as a file
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment