mysqli_real_escape_string() expects exactly 2 parameters, 1 given

Question

if (phpversion() >= '4.3.0'){
    $string = mysqli_real_escape_string($string);
}else{
    $string = mysqli_escape_string($string);
}

All the documentation for mysqli_real_escape_string seems to indicate this is a valid bit of code, but I don't understand why I get this error:

mysqli_real_escape_string() expects exactly 2 parameters, 1 given

Answer 1

Documentation says it needs two parameters:

string mysqli_real_escape_string ( mysqli $link , string $escapestr )

The first one is a link for a mysqli instance, the second one is the string to escape.

Answer 2

Following is the proper format to use it :

string mysqli_real_escape_string ( mysqli $link , string $escapestr )

first parameter is mysql connection link identifier, and second is string For more details, you can visit this link : http://in2.php.net/manual/en/mysqli.real-escape-string.php.