proses_login

<?php


//memanggil konfigurasi database
include '../config.php';
////

$user = $_POST['USERNAME'];
$pass = $_POST['PASSWORD'];
$query = "SELECT * FROM TBL_USER WHERE USERNAME = '$user' and PASSWORD ='$pass'";
$hasil = oci_parse($connect, $query);
$data = oci_execute($hasil);

// VALIDASI DATA
if($data == 1){

    session_start();
    $_SESSION['ID']=$data['ID'];
    $_SESSION['NAMA']=$data['NAMA'];
    $_SESSION['USERNAME']=$data['USERNAME'];
    $_SESSION['PASSWORD']=$data['PASSWORD'];
    $_SESSION['ALAMAT']=$data['ALAMAT'];
    $_SESSION['HAK']=$data['HAK'];
    header ('location:../admin/index');
}
else{
    header('Location:../login.php?action=eror');
}
?>