<?php
                            if (isset($_POST['submit'])){
                            $username = $_POST['username'];
                            $password = $_POST['password'];


                            $result = mysqli_query($dbcon,"SELECT * FROM users WHERE username='$username' AND password='$password'")or die(mysqli_error());
                            $num_row = mysqli_num_rows($result);
                                $row=mysqli_fetch_array($result);
                                if( $num_row > 0 ) {
                                    ?>


<script>alert('Login Successful');
window.location='attendance.php';</script>
<?php

                            $_SESSION['id']=$row['user_id'];

                                }

                                else{ ?>
                            <div class="alert alert-danger">Access Denied</div>
                            <?php
                            }}
                            ?>