<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "student_course_management";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {

    $check="";
    $temp=true;

    if (isset($_POST['submit'])) {



        if (empty($_POST['email']) || empty($_POST['password'])) {
            $temp=false;
        }
        else{

            $check=true;

            $username = $_POST['email'];
            $password = $_POST['password'];

            $sql = " SELECT COUNT(*) FROM users WHERE( email ='".$username."' AND password='".$password."') ";

            $result = $conn->query($sql);

            if ($result->num_rows == 1) {

                $_SESSION['userName'] = $username;
            } else {

                $_SESSION['userName'] = "";
            }
        }
        $conn->close();
    }
}
?>