Php 5.4 to 7.1 : Mysqli_real_escape_string() 2 parameters, 1 given in

Question

Im trying to convert my Wordpress theme from PHP 5.4 to 7.1

But... I still don't understand what's happening with this error :

Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in /home/myhost/wp-content/themes/mytheme/functions.php on line 69

$con = new mysqli('localhost', 'my_user', 'my_password', 'my_db');


function cG($name){
    if(get_magic_quotes_gpc()) $_GET[$name]=stripslashes($_GET[$name]); 
    $name=mysqli_real_escape_string($con, $_GET[$name]);
    return $name;
}

I tried to follow this, but even I get the error... Any idea ? Thank you!

Did you var_dump `$_GET[$name]`? – B001ᛦ Aug 23 '17 at 15:39 — B001ᛦ, Aug 23 '17 at 15:39

score 0 · Accepted Answer · answered Aug 23 '17 at 18:21

magic_quotes_gpc is deprecated as of PHP 5.3 and removed as of PHP 5.4 ... so your check here is useless ... And keep in mind that your connection string isn't visible inside the function, You'll either have to accept it as an argument or use global keyword which isn't a good solution.

Accepting as an arugment:

function cG($con, $name){
    $name=mysqli_real_escape_string($con, $_GET[$name]);
    return $name;
}

cG($con, 'something');

or using global keyword:

function cG($name){
    global $con;
    $name=mysqli_real_escape_string($con, $_GET[$name]);
    return $name;
}

Php 5.4 to 7.1 : Mysqli_real_escape_string() 2 parameters, 1 given in

1 Answers1