ci mysql 不等于,codeIgniter使用mysql_real_escape_string（）而不是数据库连接问题

I have code igniter installed on server with database I want to run the same db on my mac, I used MAMP and I copy the project folder inside htdocs, but I have this error

would you please help me!

ErrorException [ 8192 ]: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

解决方案

Don't be afraid to change core files, just alter FCPATH/system/database/drivers/mysqli/mysqli_driver.php

function escape_str($str, $like = FALSE)

{

if (is_array($str))

{

foreach ($str as $key => $val)

{

$str[$key] = $this->escape_str($val, $like);

}

return $str;

}

if (function_exists('mysqli_real_escape_string') AND is_object($this->conn_id))

{

$str = mysqli_real_escape_string($this->conn_id, $str);

}

else

{

$str = addslashes($str);

}

// escape LIKE condition wildcards

if ($like === TRUE)

{

$str = str_replace(array('%', '_'), array('\\%', '\\_'), $str);

}

return $str;

}

I had the same issue

Better solution -> https://ellislab.com/forums/viewthread/228288/ "stated in github that it will be fixed in CodeIgniter 3.0 the fix already exists in that repository"