<?php
    session_start();
    include 'koneksi.php';
    if(isset($_POST['login'])){
        $username = $_POST['username'];
        $password = $_POST['password'];

        $query = "SELECT * FROM users WHERE username = '$username' ";
        $hasil = mysqli_query($conn, $query);
        $data  = mysqli_fetch_array($hasil);

        if($password == $data['password']){

            $_SESSION['username'] = $data['username'];
            $_SESSION['password'] = $data['password'];
            $_SESSION['status']   = $data['status'];

            echo "<script> alert('Login Berhasil ".$_SESSION['status']."') </script>";

        }else{
            echo "<script> alert('Login Gagal') </script>";
        }
    }
 ?>
<form method="POST" action="">
    <input type="text" name="username" placeholder="Username"><br>
    <input type="password" name="password" placeholder="Password"><br>
    <input type="submit" name="login" value="Login">
</form>