Warning: real_escape_string

Bonjour,


J'ai un problème avec mon code php:

voici les erreurs :

warning:mysqli:mysqli()[mysqli.mysqli]:(2800/1045): Access denied for user 'USERNAME'@'localhost' (using password:YES) in C:\Program Files\xampp\htdocs\autocomplete/rpc.php on line 5

warning:mysqli:mysqli:real_escape_string()[mysqli.real-escape-string]:couldn't fetch musqli in C:\Program Files\xampp\htdocs\autocomplete/rpc.php on line 13

J'ai cherché sur google pour voir la fonction real_escape_string , est obsolète .

Je ne comprend pas d'où peut venir le problème .

voici le code php:

<?php

// PHP5 Implementation - uses MySQLi.
// mysqli('localhost', 'aimeric', 'roffbmw94', 'countries');
$db = new mysqli('localhost', 'USERNAME' ,'PASSWORD', 'DATABASE');

if(!$db) {
// Show error if we cannot connect.
echo 'ERROR: Could not connect to the database.';
} else {
// Is there a posted query string?
if(isset($_POST['queryString'])) {
$queryString = $db->real_escape_string($_POST['queryString']);

// Is the string length greater than 0?

if(strlen($queryString) >0) {
// Run the query: We use LIKE '$queryString%'
// The percentage sign is a wild-card, in my example of countries it works like this...
// $queryString = 'Uni';
// Returned data = 'United States, United Kindom';

// YOU NEED TO ALTER THE QUERY TO MATCH YOUR DATABASE.
// eg: SELECT yourColumnName FROM yourTable WHERE yourColumnName LIKE '$queryString%' LIMIT 10

$query = $db->query("SELECT your_column FROM your_db_table WHERE your_column LIKE '$queryString%' LIMIT 10");
if($query) {
// While there are results loop through them - fetching an Object (i like PHP5 btw!).
while ($result = $query ->fetch_object()) {
// Format the results, im using <li> for the list, you can change it.
// The onClick function fills the textbox with the result.

// YOU MUST CHANGE: $result->value to $result->your_colum
echo '<li onClick="fill(\''.$result->value.'\');">'.$result->value.'</li>';
}
} else {
echo 'ERROR: There was a problem with the query.';
}
} else {
// Dont do anything.
} // There is a queryString.
} else {
echo 'There should be no direct access to this script!';
}
}
?>


Merci d'avance.