<?php
include("koneksi.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Login Admin Perpustakaan</title>
<style type="text/css">
body {
margin:20px;
background-color:#999999;
}
#FormLogin {
width:400px;
margin:0 auto;
border:1px solid #444;
padding:20px;
background-color:#000099;
border-radius:20px;
color:#fff;
}
#FormLogin h1 {
text-align:center;
border-bottom:1px solid #ccc;
padding:10px;
margin:5px;
;
font-size:22px;
}
#FormLogin label {
float:left;
width:150px;
}
#FormLogin .text {
margin-bottom:5px;
}
</style>
</head>
<body>
<?php
//Penangganan login jika form diisi
if (isset($_POST['username']) && isset ($_POST['password']))
{
//cek isi data
if(!empty($_POST['username']) && !empty($_POST['password']))
{
$username=htmlspecialchars(stripslashes($_POST['username']));
$password=md5(htmlspecialchars(stripslashes($_POST['password'])));
$myquery="select username,nama,DATE_FORMAT(login_terakhir, '%d-%m-%Y') as login_terakhir from admin where username='$username' and password='$password' limit 1";
$result=mysql_query($myquery) or die (mysql_error());
if (mysql_num_rows($result) == 1)
{
//jika username dan password cocok
$pengguna=mysql_fetch_object($result);
$_SESSION['login']=true;
$_SESSION['username']=$pengguna->username;
$_SESSION['nama']=$pengguna->nama;
$_SESSION['login_terakhir']=$pengguna->login_terakhir;
mysql_query("update admin set login_terakhir=NOW() where username='$username' limit 1") or die("Gagal memperbaharui terakhir login");
header("location:home.php");
} else {
//jika username dan password tidak cocok
echo "<h1 align=\"center\">Username atau password salah!</h1>";
}
}else{
//jika form kosong munculkan pesan
echo "<h1 align=\"center\">Isikan username dan password!</h1>";
}
}
?>
<div id="FormLogin">
<h1>SISTEM PEMINJAMAN BUKU</h1>
<form id="FLogin" name="FLogin" method="post" action="">
<label>Username</label>
:
<input name="username" type="text" id="username" size="20" maxlength="20" class="text" />
<br />
<label>Password</label>
:
<input name="password" type="password" id="password" size="20" maxlength="20" class="text" />
<br />
<p align="center">
<input type="submit" name="button" id="button" value="Login" />
<input type="reset" name="Reset" id="button" value="Reset" />
</p>
</form>
</div>
</body>
</html>
include("koneksi.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Login Admin Perpustakaan</title>
<style type="text/css">
body {
margin:20px;
background-color:#999999;
}
#FormLogin {
width:400px;
margin:0 auto;
border:1px solid #444;
padding:20px;
background-color:#000099;
border-radius:20px;
color:#fff;
}
#FormLogin h1 {
text-align:center;
border-bottom:1px solid #ccc;
padding:10px;
margin:5px;
;
font-size:22px;
}
#FormLogin label {
float:left;
width:150px;
}
#FormLogin .text {
margin-bottom:5px;
}
</style>
</head>
<body>
<?php
//Penangganan login jika form diisi
if (isset($_POST['username']) && isset ($_POST['password']))
{
//cek isi data
if(!empty($_POST['username']) && !empty($_POST['password']))
{
$username=htmlspecialchars(stripslashes($_POST['username']));
$password=md5(htmlspecialchars(stripslashes($_POST['password'])));
$myquery="select username,nama,DATE_FORMAT(login_terakhir, '%d-%m-%Y') as login_terakhir from admin where username='$username' and password='$password' limit 1";
$result=mysql_query($myquery) or die (mysql_error());
if (mysql_num_rows($result) == 1)
{
//jika username dan password cocok
$pengguna=mysql_fetch_object($result);
$_SESSION['login']=true;
$_SESSION['username']=$pengguna->username;
$_SESSION['nama']=$pengguna->nama;
$_SESSION['login_terakhir']=$pengguna->login_terakhir;
mysql_query("update admin set login_terakhir=NOW() where username='$username' limit 1") or die("Gagal memperbaharui terakhir login");
header("location:home.php");
} else {
//jika username dan password tidak cocok
echo "<h1 align=\"center\">Username atau password salah!</h1>";
}
}else{
//jika form kosong munculkan pesan
echo "<h1 align=\"center\">Isikan username dan password!</h1>";
}
}
?>
<div id="FormLogin">
<h1>SISTEM PEMINJAMAN BUKU</h1>
<form id="FLogin" name="FLogin" method="post" action="">
<label>Username</label>
:
<input name="username" type="text" id="username" size="20" maxlength="20" class="text" />
<br />
<label>Password</label>
:
<input name="password" type="password" id="password" size="20" maxlength="20" class="text" />
<br />
<p align="center">
<input type="submit" name="button" id="button" value="Login" />
<input type="reset" name="Reset" id="button" value="Reset" />
</p>
</form>
</div>
</body>
</html>
0 komentar:
Posting Komentar