Fatal error: Call to undefined function mysql_real_escape_string()

Question

Fatal error: Call to undefined function mysql_real_escape_string() in /var/www/engine/database.php on line 38

I can still connect to the database however. Why is it not available?

I am using PHP version 7.1.4

which mysql connectivity are you using. are you using `mysqli` ? — Bhunesh Satpada, Jun 23 '17 at 05:25
Possible duplicate of [Fatal error: Uncaught Error: Call to undefined function mysql\_connect()](https://stackoverflow.com/questions/34579099/fatal-error-uncaught-error-call-to-undefined-function-mysql-connect) — Scopey, Jun 23 '17 at 05:27
@BhuneshSatpada I didnt get ur question about mysql connectivity. Could u give some clarity on your question — Jon Andrews, Jun 23 '17 at 05:28

score 7 · Answer 1 · answered Jun 23 '17 at 05:29

7

mysql_ has been removed in php 7. try mysqli_real_escape_string instead of mysql_real_escape_string.

answered Jun 23 '17 at 05:29

Bhunesh Satpada

Error : mysqli_real_escape_string() expects exactly two parameters. but we have only one parameter. mysqli_real_escape_string($username) – Jon Andrews Jun 23 '17 at 05:36
you need to provide first parameter is your connection variable and other one is posted parameter. so your syntax will will `mysqli_real_escape_string($con, $_POST['name'])` [link] (https://www.w3schools.com/php/func_mysqli_real_escape_string.asp) – Bhunesh Satpada Jun 23 '17 at 05:43
can you post your database connectivity code? – Bhunesh Satpada Jun 23 '17 at 05:45
Problem solved. Thank You – Jon Andrews Jun 23 '17 at 05:46
Great. It fixed my many problem – Md. Amanur Rahman Oct 07 '19 at 14:59

score 1 · Answer 2 · answered Jun 23 '17 at 05:30

1

The mysql extension has been deprecated from PHP 5.5. Use mysqli extension should be used.

You can try mysqli_real_escape_string() for your PHP Version.

answered Jun 23 '17 at 05:30

Sonali Hajarnis

Error : mysqli_real_escape_string() expects exactly two parameters. but we have only one parameter. mysqli_real_escape_string($username) – Jon Andrews Jun 23 '17 at 05:34
Syntax :- mysqli_real_escape_string(connection,escapestring); $con=mysqli_connect("localhost","my_user","my_password","my_db"); $username = mysqli_real_escape_string($con, $username); – Sonali Hajarnis Jun 23 '17 at 05:36
What should I pass as the connection parameter – Jon Andrews Jun 23 '17 at 05:37
Problem solved Thankyou – Jon Andrews Jun 23 '17 at 05:47

2 Answers2