Possible duplicate:
Do I need to use mysql_real_escape_string if I bind parameters?
I have a quick MySQLi security question ...
For example, look at this code (receives input from the user, checks it against the database to see if a combination of username and password exists):
$input['user'] = htmlentities($_POST['username'], ENT_QUOTES);
$input['pass'] = htmlentities($_POST['password'], ENT_QUOTES);
if ($stmt = $mysqli->prepare("SELECT * FROM members WHERE username=? AND password = ?"))
{
$stmt->bind_param("ss", $input['user'], md5($input['pass'] . $config['salt']));
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0)
{}
}
In this case, I use htmlentities () for the form data and using the prepared MySQLi statement. Should I still use mysql_real_escape_string ()?
source
share