<div class="alert alert-danger <?php if(!isset($error)) echo 'hide';?>">
                            Invalid username/password! Email administrator in link below to recover it.
                        </div>
                        <div class="alert alert-warning <?php if(!isset($inactive)) echo 'hide';?>">
                            This account is no longer valid. Thank you!
                        </div>
                        <div style="display:none" id="login-alert" class="alert alert-danger col-sm-12"></div>

<?php
        include('connection.php');
        if (isset($_POST['proceed'])) {
                $username = $_POST['login'];
                $password = $_POST['password'];
                /***** GUIDANCE *****/
                $guidance = "SELECT * FROM faculty WHERE Faculty_ID = ? AND Password = ? AND Position='Guidance' ";
                $stmt = $conn->prepare($guidance);
                $stmt->bind_param('is', $username, $password);
                $stmt->execute();
                $result = $stmt->get_result();



                $student = "SELECT * FROM student WHERE Student_ID = ? AND Password = ? ";
                $stmt = $conn->prepare($student);
                $stmt->bind_param('is', $username, $password);
                $stmt->execute();
                $result2 = $stmt->get_result();
                if ($result -> num_rows > 0) {

                    $row = $result -> fetch_object();
                        if($row->Status!='Active'){
                            $inactive = 1;
                            }else{
                            $_SESSION['access'] = 1;
                            $_SESSION['login'] = $row -> Faculty_ID;
                            $_SESSION['Faculty_Firstname'] = $row -> Faculty_Firstname;
                            header('Location: guidance/index.php');
                        }
                                elseif ($result2 -> num_rows > 0) {

                                $row = $result2 -> fetch_object();
                                    $_SESSION['access'] = 3;
                                    $_SESSION['Student_ID'] = $row -> Student_ID;
                                    //$_SESSION[] = $row ->
                                    header('Location:student/index.php ');
                    }else{
                                $error = 1;
                }
                }
?>