login

<?php
                    session_start();
                    require_once("../connection.php");
                    $user_username = $_POST['user_username'];
                    $user_password = $_POST['user_password'];
                    $sql = "SELECT * FROM tw_user WHERE  user_username = '$user_username'";
                    $query = $db->query($sql);
                    $hasil = $query->fetch(PDO::FETCH_ASSOC);
                    if($user_username <> $hasil['user_username']) {
                      echo "<div class='text-center'>Nama pengguna Belum Terdaftar! <a href='../id/masuk'>Kembali</a></div>";
                    } else {
                    if($user_password <> $hasil['user_password']) {
                      echo "<div class='text-center'>Kata sandi salah! <a href='../id/masuk'>Kembali</a></div>";
                    } else {
                    $_SESSION['user_id'] = $hasil['user_id'];
                    $_SESSION['user_date'] = $hasil['user_date'];
                    $_SESSION['user_picprofil'] = $hasil['user_picprofil'];
                    $_SESSION['user_username'] = $hasil['user_username'];
                    $_SESSION['user_name'] = $hasil['user_name'];
                    $_SESSION['user_first_name'] = $hasil['user_first_name'];
                    $_SESSION['user_last_name'] = $hasil['user_last_name'];
                    $_SESSION['user_email'] = $hasil['user_email'];
                    $_SESSION['user_password'] = $hasil['user_password'];
                    $_SESSION['group_name'] = $hasil['group_name'];

                    if($_SESSION['group_name'] == 'Administrator')
                    echo '<div class="text-center">Mengarahkan ke halaman Admin <meta http-equiv="Refresh" Content="1; URL=../id/admin/"></div>';
                    exit();
                    if($_SESSION['group_name'] == 'Member')
                    echo '<div class="text-center">Mengarahkan ke halaman Member <meta http-equiv="Refresh" Content="1; URL=../id/member/"></div>';
                    exit();
                    }
                }
                ?>