I currently have a successfully created a login following my recent post - Simple SQL query selecting from table where email = email
I've encrypted the password, but unsure on how I can offer protection from SQL injections, could anyone please offer some suggestions or resources on how I can protect my script please ?
$user = stripslashes($user);
$pass = stripslashes($pass);
$password = md5 ( $pass );
$sql = "SELECT * FROM members WHERE email='$email' AND password='$password'";
$result = mysqli_query( $connect, $sql);
$row = mysqli_fetch_array($result);
if(!$row){
echo "Incorrect Username or password";
}
else{
echo "Logged in";
}
mysqli_close( $connect );