<?php
include ("includes/database.php");
if(!isset($_SESSION))
{
session_start();
}// Starting Session
$error = ''; // Variable To Store Error Message
if (isset($_POST['submit'])) {
    if (empty($_POST['employee_name']) || empty($_POST['employee_password'])) {
        $error = "Username or Password is invalid";
    } else {
            $username = stripslashes($_POST['employee_name']);
            $password = stripslashes($_POST['employee_password']);

            $result = "select * from employee where employee_name ='$username'";

            if ($res = $db->query($result))
                {
                if($res->fetchcolumn()>0)
                {
                    foreach ($db->query($result) as $row)
                    {
                        if($row['employee_password'])
                        {
                            $_SESSION['employeeID'] = $row['employeeID'];
                        }

                    }
                }
                header("location: index.php"); // Redirecting To Other Page
            } else {
                $error = "Username or Password is invalid";
            }

            // close result set (free the result set memory)
            mysqli_free_result($result);

            mysqli_close($connection); // Closing Connection
        }
    }

?>