Selasa, 16 Juli 2013
tampil_data.php
<?php
include ("koneksi.php"); //ini sudah ada sebelumnya
if(!isset($_SESSION['login'])) {
header("location:login.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" xml:lang="en">
<head>
<title>PERPUSTAKAAN</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="title" content="Web site" />
<meta name="description" content="Site description here" />
<meta name="keywords" content="keywords here" />
<meta name="language" content="en" />
<meta name="subject" content="Site subject here" />
<meta name="robots" content="All" />
<meta name="copyright" content="Your company" />
<meta name="abstract" content="Site description here" />
<meta name="MSSmartTagsPreventParsing" content="true" />
<link id="theme" rel="stylesheet" type="text/css" href="style.css" title="theme" />
<script type="text/javascript" language="javascript" src="js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="js/custom.js"></script>
<script type="text/javascript" language="javascript" src="js/addon.js"></script>
</head>
<body>
<div id="top">
<div class="overlay"></div>
</div>
<div id="wrapper">
<div class="overlay"></div>
<div class="border-top"></div>
<div class="content">
<div id="container">
<div class="hd">
<div id="container-top"></div>
<div id="banner"></div>
<div id="hmenu-wpr">
<ul id="hmenu" class="sf-menu sf-js-enabled sf-shadow">
<li class="current" style="border:none">
<a class="toplvl sf-with-ul" href="tampildata.php?page=tampil anggota">TAMPIL ANGGOTA</a>
</li>
<li>
<a href="tampildata.php?page=tampil buku" class="toplvl">TAMPIL BUKU</a>
</li>
<li>
<a href="tampildata.php?page=laporan peminjaman" class="toplvl">LAPORAN PEMINJAM</a>
</li>
<li>
<a href="home.php" class="toplvl">BACK</a>
</li>
</ul>
</div>
</div>
<div class="bd">
<div id="page">
<!-- SIDEBAR -->
<!-- END SIDEBAR -->
<!-- MAIN COLUMN -->
<div id="main">
<div class="content">
<p>
<?php
$page=(isset($_GET['page']))? $_GET['page']: "main";
switch($page){
case 'tampil anggota' :
include "tampil_anggota.php";
break;
case 'tampil buku' :
include "tampil_buku.php";
break;
case 'laporan peminjaman' :
include "tampil_peminjaman.php";
break;
case 'main' :
default : include 'utama.php';
}
?>
</p>
</div>
</div>
<!-- END MAIN -->
<div class="clear" style="height:60px"></div>
</div>
</div>
<div class="ft">
<div id="footer">
<div class="content">
<!--
Keep this footer link UNCHANGED AND VISIBLE or make a 10 dollars donation at www.dotemplate.com/#donate to remove it.
-->
<p>
Copyright (c) 2013 Abd Latif. All Right Reserved
</p>
</div>
</div>
<div id="container-bottom"></div>
</div>
</div>
</div>
</div>
<div class="clear"></div>
</body>
</html>
include ("koneksi.php"); //ini sudah ada sebelumnya
if(!isset($_SESSION['login'])) {
header("location:login.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" xml:lang="en">
<head>
<title>PERPUSTAKAAN</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="title" content="Web site" />
<meta name="description" content="Site description here" />
<meta name="keywords" content="keywords here" />
<meta name="language" content="en" />
<meta name="subject" content="Site subject here" />
<meta name="robots" content="All" />
<meta name="copyright" content="Your company" />
<meta name="abstract" content="Site description here" />
<meta name="MSSmartTagsPreventParsing" content="true" />
<link id="theme" rel="stylesheet" type="text/css" href="style.css" title="theme" />
<script type="text/javascript" language="javascript" src="js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="js/custom.js"></script>
<script type="text/javascript" language="javascript" src="js/addon.js"></script>
</head>
<body>
<div id="top">
<div class="overlay"></div>
</div>
<div id="wrapper">
<div class="overlay"></div>
<div class="border-top"></div>
<div class="content">
<div id="container">
<div class="hd">
<div id="container-top"></div>
<div id="banner"></div>
<div id="hmenu-wpr">
<ul id="hmenu" class="sf-menu sf-js-enabled sf-shadow">
<li class="current" style="border:none">
<a class="toplvl sf-with-ul" href="tampildata.php?page=tampil anggota">TAMPIL ANGGOTA</a>
</li>
<li>
<a href="tampildata.php?page=tampil buku" class="toplvl">TAMPIL BUKU</a>
</li>
<li>
<a href="tampildata.php?page=laporan peminjaman" class="toplvl">LAPORAN PEMINJAM</a>
</li>
<li>
<a href="home.php" class="toplvl">BACK</a>
</li>
</ul>
</div>
</div>
<div class="bd">
<div id="page">
<!-- SIDEBAR -->
<!-- END SIDEBAR -->
<!-- MAIN COLUMN -->
<div id="main">
<div class="content">
<p>
<?php
$page=(isset($_GET['page']))? $_GET['page']: "main";
switch($page){
case 'tampil anggota' :
include "tampil_anggota.php";
break;
case 'tampil buku' :
include "tampil_buku.php";
break;
case 'laporan peminjaman' :
include "tampil_peminjaman.php";
break;
case 'main' :
default : include 'utama.php';
}
?>
</p>
</div>
</div>
<!-- END MAIN -->
<div class="clear" style="height:60px"></div>
</div>
</div>
<div class="ft">
<div id="footer">
<div class="content">
<!--
Keep this footer link UNCHANGED AND VISIBLE or make a 10 dollars donation at www.dotemplate.com/#donate to remove it.
-->
<p>
Copyright (c) 2013 Abd Latif. All Right Reserved
</p>
</div>
</div>
<div id="container-bottom"></div>
</div>
</div>
</div>
</div>
<div class="clear"></div>
</body>
</html>
koneksi.php
<?php session_start('login');
mysql_connect("localhost","root","") or die ("Koneksi Gagal!!");
mysql_select_db("dbperpus") or die ("database tidak di temukan!!");
?>
mysql_connect("localhost","root","") or die ("Koneksi Gagal!!");
mysql_select_db("dbperpus") or die ("database tidak di temukan!!");
?>
login.php
<?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>
Langganan:
Postingan (Atom)
