codeigniter - why am i getting an error from file mysqli/mysqli_driver.php?

Solution:

mysqli_real_escape_string() is used to prepare text data too be save in an SQL Record Column.<br>And the data being wrint to that column does not exist.<br><br>
Copy code

Go tomysqli_driver.php to Line #315 and put an at mark in fron of the command to supress the warning.

From:

 mysqli_real_escape_string() 
Copy code

To:

 @mysqli_real_escape_string() 
Copy code

If the value you are escaping is an integer, then use intval() instead:
This will turn a NULL into a Zero

$var = intval($var);
Copy code

Solution:

Instead of hide warnings with @, check that conn_id is not false:

change

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

like that

if($this->conn_id){
    $str = mysqli_real_escape_string($this->conn_id, $str);
}
Copy code

Solution:

My solution was to initialize the connection if it is not available. Change line #315:

if ($this->conn_id === FALSE)
{
    $this->initialize();
}
$str = mysqli_real_escape_string($this->conn_id, $str); 
Copy code

Solution:

I met this problem too. Wolfgang's solution works well for me.

And if you use codeIgniter, change database config$db['default']['autoinit'] = TRUE; can also solve the problem.