login

<?php
session_start();
require_once"konmysqli.php";

?>
<html lang="en">

<!-- Head -->
<head>

<title>PresensiLabsiUG</title>

<!-- Meta-Tags -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="keywords" content="Techno Login Form Responsive, Login Form Web Template, Flat Pricing Tables, Flat Drop-Downs, Sign-Up Web Templates, Flat Web Templates, Login Sign-up Responsive Web Template, Smartphone Compatible Web Template, Free Web Designs for Nokia, Samsung, LG, Sony Ericsson, Motorola Web Design">
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- //Meta-Tags -->

<!-- Custom-Style-Sheet -->
<!-- Index-Page-CSS --> <link rel="stylesheet" href="login/css/style.css" type="text/css" media="all">
<!-- //Custom-Style-Sheet -->

<!-- Fonts -->
<link rel="stylesheet" href="//fonts.googleapis.com/css?family=Roboto:100,300,400,500,700,900" type="text/css" media="all">
<link rel="stylesheet" href="//fonts.googleapis.com/css?family=Montserrat:400,700"			   type="text/css" media="all">
<!-- //Fonts -->

</head>
<!-- //Head -->


<!-- Body -->
<body>
<h1>Aplikasi Rekapitulasi Kehadiran Asisten<br>
Laboratorium Sistem Informasi <br>
Universitas Gunadarma</h1>
<div class="containerw3layouts-agileits">
		<div class="w3imageaits">
			<img src="login/images/gundar.png" alt="" width="283" height="245">		</div>
		<div class="aitsloginwthree w3layouts agileits">
			<h2>Log In to enter the Web</h2>


			<form action="" method="post">
				<input type="text" Name="user" placeholder="Username" required="">
				<input type="password" Name="pass" placeholder="Password" required="">
				<ul class="tick w3layouts agileinfo">
					<li>
						<input type="checkbox" id="brand1" value="">
						<label for="brand1"><span></span>Remember me</label>
					</li>
					<li>
						<a href="bantuan.php">Help?</a>
					</li>
				</ul>
				<div class="send-button wthree agileits">
					<input type="submit" value="Sign In" id="Login" name="Login">
				</div>
			</form>
		</div>

		<div class="clear"></div>

</div>

	<div class="w3lsfooteragileits">
		<p> Developed by <b> Pudji Nuriyanti </b> | Design by <a href="http://w3layouts.com" target="=_blank">W3layouts</a></p>
	</div>


</body>
<!-- //Body -->
</html>
<?php
if(isset($_POST["Login"])){
	$usr=$_POST["user"];
	$pas=$_POST["pass"];

		$sql1="select * from `tb_admin` where `username`='$usr' and `password`='$pas'";
		$sql2="select * from `tb_asisten` where `username`='$usr' and `password`='$pas'";
		$sql3="select * from `tb_pj` where `username`='$usr' and `password`='$pas'";

		if(getJum($conn,$sql1)>0){
			$d=getField($conn,$sql1);
				$kode=$d["id_admin"];
				$nama=$d["username"];
				$jabatan=$d["jabatan"];
				   $_SESSION["cid"]=$kode;
				   $_SESSION["cnama"]=$nama;
				   $_SESSION["cstatus"]=$jabatan;
		echo "<script>alert('Otentikasi ".$_SESSION["cstatus"]." ".$_SESSION["cnama"]." (".$_SESSION["cid"].") berhasil Login!');
		document.location.href='index.php?mnu=home';</script>";
	    }
		else if(getJum($conn,$sql2)>0){
			$d=getField($conn,$sql2);
				$kode=$d["id_asisten"];
				$nama=$d["username"];
				   $_SESSION["cid"]=$kode;
				   $_SESSION["cnama"]=$nama;
				   $_SESSION["cstatus"]="Asisten";
		echo "<script>alert('Otentikasi ".$_SESSION["cstatus"]." ".$_SESSION["cnama"]." (".$_SESSION["cid"].") berhasil Login!');
		document.location.href='index.php?mnu=home';</script>";
	    }
		else if(getJum($conn,$sql3)>0){
			$d=getField($conn,$sql3);
				$kode=$d["id_pj"];
				$nama=$d["username"];
				   $_SESSION["cid"]=$kode;
				   $_SESSION["cnama"]=$nama;
				   $_SESSION["cstatus"]="PJ";
		echo "<script>alert('Otentikasi ".$_SESSION["cstatus"]." ".$_SESSION["cnama"]." (".$_SESSION["cid"].") berhasil Login!');
		document.location.href='index.php?mnu=home';</script>";
		}
		else{
			session_destroy();
			echo "<script>alert('Otentikasi Login GAGAL ! Silakan cek data Anda kembali...');
			document.location.href='index.php?mnu=login';</script>";
		}
}

?>
<script type="text/javascript">
	function validasi() {
		var username = document.getElementById("username").value;
		var password = document.getElementById("password").value;
		if (username != "" && password!="") {
			return true;
		}else{
			alert('Username dan Password harus di isi !');
			return false;
		}
	}
// When the user presses any key on the keyboard, run the function
input.addEventListener("keyup", function(event) {

  // If "caps lock" is pressed, display the warning text
  if (event.getModifierState("CapsLock")) {
    text.style.display = "block";
  } else {
    text.style.display = "none"
  }
}); </script>

<?php
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
  $rs = $conn->query($sql);
  if($rs){
	    $conn->commit();
	    $last_inserted_id = $conn->insert_id;
 		$affected_rows = $conn->affected_rows;
  		$s=true;
  }
}
catch (Exception $e) {
	echo 'fail: ' . $e->getMessage();
  	$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}

function getJum($conn,$sql){
  $rs=$conn->query($sql);
  $jum= $rs->num_rows;
	$rs->free();
	return $jum;
}

function getField($conn,$sql){
	$rs=$conn->query($sql);
	$rs->data_seek(0);
	$d= $rs->fetch_assoc();
	$rs->free();
	return $d;
}
?>