0

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 );
Community
  • 1
  • 1
Ryan
  • 271
  • 2
  • 3
  • 7

0 Answers0