hmm_s.php

<?php
$conn=mysqli_connect("localhost","root","","project");
if(isset($_POST['Email']) && isset($_POST['Password']) )
{
  function validate($data)
  {
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
  }
  $Email=validate($_POST['Email']);
  $Password=validate($_POST['Password']);

  if(empty($Email))
  {
     header("Location:s_login.php?error=Email is required");
    exit();
  }
  else if(empty($Password))
  {
    header("Location:s_login.php?error=Password is required");
    exit();
  }
  else{
    $sql="select * from students where Email='$Email'
    and Password='$Password'";

    $result = mysqli_query($conn,$sql);
    if(mysqli_num_rows($result) === 1)
    {
       $row = mysqli_fetch_assoc($result);
       if($row['Email'] === $Email && $row['Password'] === $Password)
       {
          header("Location: student_dashboard.php?email=$Email");
       }
    }
    else{
           header("Location: s_login.php?error=Incorrect Email or Password");
    exit();
    }

  }

}
else
{
    header("Location: welcome.php");
    exit();
}
 
?>