mysqli_real_escape_string() not working properly

[font=times new roman][size=10pt][/size][/font]
silly though but mysqli_real_escape_string is not working for me??
here is the code
[php]<?php

$cn=mysqli_connect('localhost','user','pass','db') or die 
("Could Not Connect");

var_dump($_GET[‘name’]);//gives correct results
echo"
----
";
/*
$var=get_magic_quotes_gpc();
var_dump($var);
*/
//gives int(0)
echo"
%
";
if($_GET[‘submit’]){

$htmlText = mysqli_real_escape_string($_GET[‘name’]) or die(‘error with escaping’);//even if i include the optional link identifier here nochange
var_dump($htmlText);//gives NULL

}

/i have checked if the function exists using function_exists(mysql_real_escape_string);and its giving true/
/--------CLOSING PROCEDURES-------/
mysqli_close();
//none of the die statements are getting executed
?>[/php]

somebody please help::::

mysqli_real_escape_string needs to be mysql_real_escape_string.

Actually, function mysqli_real_escape_string exists, but in PHP 5 only. And yes, it is safe to use mysql_real_escape_string() with mysqli database.

Sponsor our Newsletter | Privacy Policy | Terms of Service