Coding website - SKRPIS RANCANG BAUNGUN PERPUSTAKAAN BERBASIS WEBSITE DI SMK N 1 KABUPATEN YAHUKIMO
Headlines News :
Home » » Coding website

Coding website

Written By Unknown on Jumat, 29 Mei 2015 | 07.13



<html>
<head>
<title>.:: Sistem Informasi Manajemen Perpustakaan ::.</title>
<style type="text/css">
body {
                background-color: #003300;
                color: black;
                margin-top: 0px;
                margin-left: 50px;
                margin-right: 50px;
                font-family: arial;
                font-size: 14px;
                background-image: url(../../../Users/RECKY/Pictures/GRRN/Screenshot_79.png);
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>

<body>
<center>
<table border=0 width="900px" bgcolor="orens" colspan="0">
                <tr>
                                <td colspan="2">
                                <marquee>
                                <b> Selamat Datang di website Perpustakaan SMK N 1 Kab Yahukimo Tahun 2015</b>
                                </marquee>
                                </td>
                </tr>
                <tr>
                                <td colspan="2" width="900px" height="200px"><img src="image/header.jpg" width="100%" height="180px"></td>
                </tr>
               
                <tr>
                <form action="login.php" name="login" method="post">
                                <td colspan="2" valign="baseline" bgcolor="#000066" style="background: ; padding: 8px 0 8px 0">
                                 <p><marquee><b><h2>
                                 <font size="7px" color="#FFFFFF"><strong><em>Silahkan Login Dengan Username &amp; password Anda</em></strong></font>
         <strong><em><strong></em></strong><em>
         <h2>
         </b></em>
         </marquee></p>
         </strong><strong></strong>
                                <font size="5px" color="#FFFFFF"<p>Username : <input type="text" name="user" placeholder="masukkan username anda" required></p><p> Password : <input type="password" name="pass" placeholder="masukkan password anda" required> </p>
                                <p><input type="submit" value="login"></p>
                                </td>
                </form>
                </tr>
                <tr>
                <td width="60%" valign="top" align="center" >
                <?php
                include "pengunjung/pengunjung.php";
                include "include/fungsi2.php";
                ?>
                </td>
                <td width="40%" style="background: yellow">
                <?php
                include "include/deteksi.php";
                ?></td>
                <tr>
                <td colspan="2" align="center" bgcolor="#000099" style="background: Yellow; border-top: solid 2px black; font-size: 12px"><strong>&copy; copyright : LEPANUS LOKON. &nbsp;TA-TEKNIK 2015 PERPUSTAKAAN SMK NEGERI 1 KAB YAHUKIMO<br>All Right Reserved</strong></td>
                </tr>
</table>
</center>





















Frmat 2
<?php
session_start();
include "../include/fungsi2.php";
$sesi      = $_SESSION['sesi'];

if($_SESSION['sesi'] == "" || $_SESSION['sesi']  == NULL || empty($_SESSION['sesi'])){
                echo "<center><font color='red'>Anda tidak diperkenankan memasuki halaman ini, jika anda belum <a href='../index.php'>login</a> !!</font></center>";
                exit;
}
function logout() {
                session_start();
                session_destroy();
                echo "<meta http-equiv='refresh' content='0; url=../index.php'>";
}

$utama="<center><span class='s'>Selamat Datang di Sistem Informasi Perpustakaan SMK N 1 Yahukimo. Untuk menggunakan, silakan memilih menu di samping kiri !. <br><br><Sta></Sta>tus Anda login sebagai <b>\" $sesi \"</b> Jangan lupa LOG OUT sebelum keluar . . .</span></center>";
?>

<html>
<head>
<title>.:: Sistem Informasi Berbasis Web Di Perpustakaan SMK Negeri 1 Yahukimo::.</title>
<link rel="stylesheet" type="text/css" href="../include/style.css" />
</head>

<body>
<table border=0 width="100%" bgcolor="#083d53" cellpadding=2 cellspacing=2 >

                <tr>
                                <td colspan="2"><img src="../image/header.jpg" width="100%" height="180px"><div style="position: absolute; width: 418px; height: 69px; z-index: 1; left:477px; top:44px" id="layer1">

                                </td>
                </tr>
                <tr>
                <td colspan=3><marquee onMouseOver="this.stop();" behavior="alternate" onMouseOut="this.start();">Halaman  Website Administrasi Perpustakaan SMK Negeri 1 Yahukimo</marquee>
                                </td>
                </tr>
                <tr>
                <td width="20%" valign="top" bgcolor="#4169e1">
                <h2>Tools Menu</h2>
                <div class="kotak">
                <ul>
                <li><a href="index.php">Home</a></li>
                <li><a href="?page=transaksi">Transaksi</a></li>
                <li><a href="?page=buku">Data Buku</a></li>
                <li><a href="?page=anggota">Data Anggota</a></li>
                <li><a href="?page=lap">Laporan</a></li>
                <li><a href="?page=utility">Utility</a></li>
                <li><a href="?page=user">Edit User</a></li>
                <li><a href="?page=logout" onClick="return confirm('Anda yakin ingin Keluar ?')" >Log Out</a></li>
                </ul><br>
               
                </td>
                <td width="80%" valign="top" >
                <h3>
                                <?php
                                                $page    = isset($_GET['page']) ? $_GET['page'] : "";
                                               
                                                if(strstr($page,"transaksi")) {
                                                $j="Menu Transaksi";
                                                } else if(strstr($page,"buku")) {
                                                $j="Menu Data Buku";
                                                } else if(strstr($page,"pengunju")) {
                                                $j="Menu Data Pengunjung";
                                                } else if(strstr($page,"user")) {
                                                $j="<!--<img src='../image/user.png' style='position: absolute;'>-->Menu Data User";
                                                } else if(strstr($page,"lap")) {
                                                $j="Menu Laporan";
                                                } else if(strstr($page,"util")) {
                                                $j="Menu Utility";
                                                } else if(strstr($page,"anggo")) {
                                                $j="Menu Anggota";
                                                } else {
                                                $j="Menu Utama";
                                                }
                                                echo $j;
                                ?>
                                                </h3>
                                                <div class="tengah">
                                <?php
                //menu transaksi
                if($page=="transaksi") {
                include "../transaksi/lihat_transaksi.php";
                } else if($page=="input_transaksi") {
                include "../transaksi/$page.php";
                } else if($page=="act_input_transaksi") {
                include "../transaksi/$page.php";
                } else if($page=="act_kembali") {
                include "../transaksi/$page.php";
                } else if($page=="act_panjang") {
                include "../transaksi/$page.php";
                //======== akhir menu transaksi =========
               
                //menu buku
                } else if($page=="buku") {
                include "../buku/lihat_buku.php";
                } else if($page=="input_buku") {
                include "../buku/$page.php";
                } else if($page=="act_input_buku") {
                include "../buku/$page.php";
                } else if($page=="edit_buku") {
                include "../buku/$page.php";
                } else if($page=="act_edit_buku") {
                include "../buku/$page.php";
                } else if($page=="act_hapus_buku") {
                include "../buku/$page.php";
                } else if($page=="detil_buku") {
                include "../buku/$page.php";
                }
                //======== akhir menu buku ================
               
                //menu pengunjung
                //else if($page=="pengunjung") {
                //include "../pengunjung/lihat_pengunjung.php";
                //======= akhir menu pengunjung ===========
               
                //----menu laporan
                else if($page=="lap") {
                include "../laporan/$page.php";
                } else if($page=="lap_peminjaman") {
                include "../laporan/$page.php";
                } else if($page=="lap_pengunjung") {
                include "../pengunjung/$page.php";
                } else if($page=="edit_laporan") {
                include "../laporan/$page.php";
                } else if($page=="act_edit_laporan") {
                include "../laporan/$page.php";
                } else if($page=="act_hapus_laporan") {
                include "../laporan/$page.php";
               
                //=============== akhir menu laporan =================
               
                // menu anggota
                } else if($page=="anggota") {
                include "../anggota/lihat_$page.php";
                //============== akhir menu anggota ==================
               
                //menu user
                } else if($page=="user") {
                include "../user/lihat_user.php";
                } else if($page=="input_user") {
                include "../user/$page.php";
                } else if($page=="act_input_user") {
                include "../user/$page.php";
                } else if($page=="edit_user") {
                include "../user/$page.php";
                } else if($page=="act_edit_user") {
                include "../user/$page.php";
                } else if($page=="act_hapus_user") {
                include "../user/$page.php";
                }
                //==========  akhir menu user  =================
               
                //menu ultilty
                else if($page=="utility") {
                include "../utility/link.php";
                } else if($page=="backup") {
                include "../utility/$page.php";
                }
                //========== akhir menu utility ===============
               
                //log out             
                else if($page=="logout") {
                logout();
                } else {
                echo $utama;
                }
                ?>
                </div>
                </td><tr>
                <td colspan="2" style="background: grren; border-top: solid 2px black; font-size: 12px" align="center">&copy; copyright : LEPANUS LOKON . &nbsp;PERPUSTAKAAN  SMK NEGERI 1 KAB YAHUKI <a href="http://www.perpus.smk.yahukimo.com/" target="_blank">YAHUKIMO</a><br>T A - T E K N I K</td>
                </tr>
</table>
Frmat 3
-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 30, 2015 at 09:37 AM
-- Server version: 5.6.16
-- PHP Version: 5.5.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `db_perpus`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `password` varchar(15) NOT NULL,
  `hak_akses` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `hak_akses`) VALUES
(1, 'perpus', 'pass', 1);

-- --------------------------------------------------------

--
-- Table structure for table `data_anggota`
--

CREATE TABLE IF NOT EXISTS `data_anggota` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `no_induk` varchar(5) NOT NULL,
  `nama` varchar(150) NOT NULL,
  `jk` varchar(2) NOT NULL,
  `kelas` varchar(5) NOT NULL,
  `ttl` varchar(100) NOT NULL,
  `alamat` varchar(250) NOT NULL,
  `foto` varchar(75) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=164 ;

--
-- Dumping data for table `data_anggota`
--

INSERT INTO `data_anggota` (`id`, `no_induk`, `nama`, `jk`, `kelas`, `ttl`, `alamat`, `foto`) VALUES
(1, '1272', 'ROBBY', 'L', '9a', 'Kulon Progo, 4 Agustus 1997', 'Samigaluh, Kulon Progo', ''),
(2, '1273', 'DON kabo', 'L', '9c', 'Kulon Progo, 27 Januari 1998', 'Kalibawang, Kulon Progo', ''),
(3, '1275', 'ANDRI SURAHMAN', 'L', '9b', 'Kulon Progo, 30 Januari 1997', 'Samigaluh, Kulon Progo', ''),
(4, '1276', 'ANI SARIYATI', 'P', '9b', 'Kulon Progo, 13 November 1998', 'Kalibawang, Kulon Progo', ''),
(5, '1278', 'ARIS BAHAGIAWAN', 'L', '9b', 'Kulon Progo, 5 November 1996', 'Samigaluh, Kulon Progo', ''),
(6, '1279', 'ATHIFAH INDRANINGRUM', 'P', '9c', 'Kulon Progo, 26 Mei 1998', 'Samigaluh, Kulon Progo', ''),
(7, '1280', 'CANDRIKA PURNIAJATI', 'P', '9a', 'Kulon Progo, 10 Juni 1996', 'Samigaluh, Kulon Progo', ''),
(8, '1281', 'CIPTA BANGUN PERSADA', 'L', '9a', 'Kulon Progo, 14 Desember 1996', 'Samigaluh, Kulon Progo', ''),
(9, '1282', 'DAMA AGUNG PRIAMBODO', 'L', '9b', 'Kotabumi, 28 Oktober 1997', 'Samigaluh, Kulon Progo', ''),
(10, '1283', 'DANANG KHOIRUDIN', 'L', '9b', 'Tangerang, 20 September 1997', ' Samigaluh, Kulon Progo', '');

-- --------------------------------------------------------

--
-- Table structure for table `data_buku`
--

CREATE TABLE IF NOT EXISTS `data_buku` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `judul` varchar(250) NOT NULL,
  `pengarang` varchar(250) NOT NULL,
  `th_terbit` varchar(4) NOT NULL,
  `penerbit` varchar(250) NOT NULL,
  `isbn` varchar(25) NOT NULL,
  `kategori` varchar(50) NOT NULL,
  `kode_klas` varchar(20) NOT NULL,
  `jumlah_buku` int(2) NOT NULL,
  `lokasi` varchar(50) NOT NULL,
  `asal` varchar(50) NOT NULL,
  `jum_temp` int(4) NOT NULL,
  `tgl_input` varchar(75) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `data_buku`
--

INSERT INTO `data_buku` (`id`, `judul`, `pengarang`, `th_terbit`, `penerbit`, `isbn`, `kategori`, `kode_klas`, `jumlah_buku`, `lokasi`, `asal`, `jum_temp`, `tgl_input`) VALUES
(2, 'Tips dan Trick PHP', 'Mr. X', '2009', 'Erlangga', '12345678', '1000', 'AA-Pegangan Guru', 1, 'Rak E5', 'Pembelian', 1, '2014-02-21 16:11:18'),
(3, '1000000 trik PHP termudah', 'Irsyad Maulana', '2011', 'Jaya Media', '9098998293', '1000000', 'BAR-Penunjang', 1, 'Rak E5', 'Pembelian', 1, '2014-02-21 16:12:07'),
(4, '1 Milyar Trick PHP Cewek', 'Agung Cintamurti ', '2009', 'Gila Media Persada', '8989787878', '1000', 'AA-Penunjang', 2, 'Rak E3', 'Pembelian', 2, '2014-02-21 16:12:54'),
(5, 'Penyebab Eror dan Solusi saat mem-PHP', 'Juniawan Ibrahimovic', '2009', 'Gila Media Persada', '7878787', '1200', 'AA-Penunjang', 9, 'Rak E3', 'Pembelian', 9, '2014-02-21 16:14:23'),
(6, 'Data Center', 'Victor M', '2015', 'UNSRIT', '0123321', '177', 'Komputer', 5, 'Tomohon', 'Tomohon', 5, '2015-04-30 13:40:30'),
(7, 'Example', 'example', '2015', 'example', '234234', '3', 'Politik', 32, 'Example', 'Example', 32, '2015-04-30 13:42:18'),
(8, 'Bahasa Indonesia', 'M Yohanes', '2015', 'UNSRIT', '3423421', '433', 'Teknik-Informatika', 7, 'Lemari 3', 'Beli', 7, '2015-04-30 15:28:35');

-- --------------------------------------------------------

--
-- Table structure for table `pengunjung`
--

CREATE TABLE IF NOT EXISTS `pengunjung` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `jk` varchar(2) NOT NULL,
  `kelas` varchar(17) NOT NULL,
  `perlu1` varchar(15) NOT NULL,
  `perlu2` varchar(15) NOT NULL,
  `perlu3` varchar(15) NOT NULL,
  `perlu4` varchar(15) NOT NULL,
  `cari` varchar(255) NOT NULL,
  `saran` varchar(255) NOT NULL,
  `tgl_kunjung` date NOT NULL,
  `jam_kunjung` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `trans_pinjam`
--

CREATE TABLE IF NOT EXISTS `trans_pinjam` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `judul_buku` varchar(250) NOT NULL,
  `id_peminjam` int(4) NOT NULL,
  `nama_peminjam` varchar(100) NOT NULL,
  `tgl_pinjam` varchar(15) NOT NULL,
  `tgl_kembali` varchar(15) NOT NULL,
  `status` varchar(10) NOT NULL,
  `ket` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Frmat 4
<?php
session_start();
$_SESSION['sesi']             = NULL;

include "include/koneksi_db.php";

$user     = isset($_POST['user']) ? $_POST['user'] : "";
$pass     = isset($_POST['pass']) ? $_POST['pass'] : "";


$qry       = mysql_query("SELECT * FROM admin WHERE username = '$user' AND password = '$pass'");
$sesi      = mysql_num_rows($qry);

if ($sesi == 1) {
                $data_admin     = mysql_fetch_array($qry);
               
                $_SESSION['sesi'] = $data_admin['username'];
               
                echo "<script>alert('Anda berhasil Log In. Username : $sesi');</script>";
                echo "<meta http-equiv='refresh' content='0; url=admin/index.php?user=$sesi'>";

} else {
                echo "<meta http-equiv='refresh' content='0; url=index.php'>";
                echo "<script>alert('Anda Gagal Log In');</script>";
}

?>
Share this article :

0 komentar:

Speak up your mind

Tell us what you're thinking... !

Comments
Comments
 
Template Design by Creating Website Published by Mas Template Free Blogger Template Top Design Set