<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db_kantinaro";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
/*
$sql = "INSERT INTO tb_login_user(user_id, username,password,akses)
VALUES ('', 'kantin', 'narotama','user')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
*/
function login($u,$p)
{
	GLOBAL $conn;
	$log="SELECT * FROM tb_login_user WHERE username='$u' and password='$p'";
	$qry=$conn->query($log);
	$jum=$qry->num_rows; //hitung jumlah
	if($jum>0)
	{
		$row = $qry->fetch_assoc();
		$_SESSION['login']=$row['user_id'];
		//update data tabel
		$sekarang=date("Y-m-d H:i:s");
		$id=$row['user_id'];
		$up=$conn->query("UPDATE tb_login_user SET last_login='$sekarang' WHERE user_id='$id'");

		//
	    echo"<script>alert('login berhasil,
		selamat Datang ".$row['akses']."');</script>";
	    echo'<script language="javascript">
        window.location.href = "index.php"
        </script>
	    ';
	}
	else
	{echo"<script>alert('login gagal');</script>";}
}
function cekdata()
{
	GLOBAL $conn;
	$sql = "SELECT * FROM tb_login_user";
	$result = $conn->query($sql);
	if ($result->num_rows == 0)
	{
	$ins=$conn->query("INSERT INTO tb_login_user VALUES ('','kantin','narotama','0','0000-00-00 00:00:00')");
	}
}
function hapus($id)
{
	GLOBAL $conn;
	$hapus=$conn->query("DELETE FROM tb_login_user WHERE user_id='$id'");
}

?>