source code sistem peminjaman alat berbasis web gratis

source code sistem peminjaman alat berbasis web gratis - Mr Reizal artikel kali ini yaitu kerja proyek saya kelas XII TKJ karena terlalu sibuk membuat sistem peminjaman alat berbasis web dengan php + mysqli di xampp

download source code ini sebenarnya source code sistem peminjaman alat berbasis web ini tidak boleh di pertontonkan atau di share karena itu saya kasih script - script dari index sampai database :)

sourcode ini saya buat saat saya membuat kerja proyek tkj smk negeri 1 jepara dengan nama PASIS ONLINE yang beranggota

1.saya sendiri muhamad reizal muhaimin (coding)
2.fajar abdi saputra (design)
3.yuni dwi indriani (publisher)

CARA MEMBUAT TOMBOL LOGIN SEBAGAI ADMIN DAN USER

Cara Membuat Login Dengan Session menggunakan Database Menggunakan Pemograman PHP dengan xampp

Pertama buat folder di htdocs xampp dan buat file index.php

<!DOCTYPE html>
<html >
<head>
  <meta charset="UTF-8">
 <title>Celine Dorayaki</title>    
 <link rel="stylesheet" type="text/css" href="assets/css/bootstrap.css">
 <link rel="stylesheet" type="text/css" href="assets/js/jquery-ui/jquery-ui.css">
 <script type="text/javascript" src="assets/js/jquery.js"></script>
 <script type="text/javascript" src="assets/js/bootstrap.js"></script>
 <script type="text/javascript" src="assets/js/jquery-ui/jquery-ui.js"></script>
 <?php include 'config/connect.php'; ?>
 <style type="text/css">
 .kotak{ 
  margin-top: 150px;
 }

.kotak .input-group{
  margin-bottom: 20px;
 }
 </style>

</head>
<body>
<div class="container">
  <?php 
  if(isset($_GET['pesan'])){
   if($_GET['pesan'] == "gagal"){
    echo "<div style='margin-bottom:-55px' class='alert alert-danger' role='alert'>
<span class='glyphicon glyphicon-warning-sign'></span>  Login Gagal !! Username dan Password Salah !!</div>
";
   }
  }
  ?>
  <div class="panel panel-default">
   <form action="login_aksi.php" method="POST">
    <div class="col-md-4 col-md-offset-4 kotak">
     <center>
<h3>
Silakan Login</h3>
</center>
<div class="input-group">
      <span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>
      <input type="text" class="form-control" placeholder="Username" name="username">
     </div>
<div class="input-group">
      <span class="input-group-addon"><span class="glyphicon glyphicon-lock"></span></span>
      <input type="password" class="form-control" placeholder="Password" name="password">
     </div>
<div class="input-group">
      <span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>
      <select name="level_user" class="form-control">
       <option value="1">Admin</option>
       <option value="2">Supplier</option>
       <option value="3">Customer</option>
      </select>
     </div>
<div class="input-group">
   
      <input type="submit" class="btn btn-primary" value="Login">
     </div>
</div>
</form>
</div>
</div>
</body>
</html>

setelah itu anda buat file bernama login_aksi.php dengan script berikut

setelah itu anda buat folder kasih nama config dan buat file yang kasih nama config.php

setelah itu buat database seperti di bawah ini atau copy kan script berikut ini kalau nggak mau ribet
jangan lupa kasih nama dorayaki:)atau anda ingin membuat database sendiri ya terserah

kalau tidak bisa mengcopy silahkan klik link berikut " CARA COPY SCRIPT DATABASE "

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 24 Jun 2017 pada 05.53
-- Versi Server: 10.1.9-MariaDB
-- PHP Version: 5.6.15

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 utf8mb4 */;

--
-- Database: `dorayaki`
--

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

--
-- Struktur dari tabel `barang`
--

CREATE TABLE `barang` (
  `kode_barang` varchar(10) NOT NULL,
  `nama_barang` varchar(20) NOT NULL,
  `stok_barang` int(5) NOT NULL,
  `ROP` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `barang`
--

INSERT INTO `barang` (`kode_barang`, `nama_barang`, `stok_barang`, `ROP`) VALUES
('D-01', 'Tepung Terigu', 150, 0),
('D-02', 'Telur', 996, 0),
('D-03', 'Gula Pasir', 800, 0),
('D-04', 'Coklat', 900, 0),
('D-05', 'Dorayaki', 998, 0);

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

--
-- Struktur dari tabel `pesan_barang`
--

CREATE TABLE `pesan_barang` (
  `kode_pesan_barang` int(5) NOT NULL,
  `nama_supplier` varchar(30) NOT NULL,
  `nama_barang` varchar(20) NOT NULL,
  `banyak_barang` int(5) NOT NULL,
  `tgl_pesan` date NOT NULL,
  `tgl_terima` date NOT NULL,
  `status_barang` varchar(15) NOT NULL,
  `status_pengiriman` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `pesan_barang`
--

INSERT INTO `pesan_barang` (`kode_pesan_barang`, `nama_supplier`, `nama_barang`, `banyak_barang`, `tgl_pesan`, `tgl_terima`, `status_barang`, `status_pengiriman`) VALUES
(4, 'Supplier Tepung', 'Tepung Terigu', 500, '2017-06-23', '2017-06-28', 'Tersedia', 'Diterima');

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

--
-- Struktur dari tabel `pesan_online`
--

CREATE TABLE `pesan_online` (
  `kode_pesan` int(5) NOT NULL,
  `nama_pemesan` varchar(30) NOT NULL,
  `alamat_pemesan` text NOT NULL,
  `telp_pemesan` varchar(15) NOT NULL,
  `banyak_pesan` int(2) NOT NULL,
  `total_biaya` int(20) NOT NULL,
  `status` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `pesan_online`
--

INSERT INTO `pesan_online` (`kode_pesan`, `nama_pemesan`, `alamat_pemesan`, `telp_pemesan`, `banyak_pesan`, `total_biaya`, `status`) VALUES
(1, 'Frans Feby', 'JL.Taman Karya', '082297012019', 1, 7000, 'Terkirim'),
(2, 'Frans', 'JL.D', '12', 1, 7000, 'Proses');

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

--
-- Struktur dari tabel `supplier`
--

CREATE TABLE `supplier` (
  `supplier_id` int(5) NOT NULL,
  `supplier_nama` varchar(20) NOT NULL,
  `supplier_alamat` text NOT NULL,
  `supplier_nohp` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `supplier`
--

INSERT INTO `supplier` (`supplier_id`, `supplier_nama`, `supplier_alamat`, `supplier_nohp`) VALUES
(1, 'Supplier Tepung', 'JL. Taman Karya', '082114814437'),
(2, 'Supplier Telur', 'JL. Swakarya', '082114814438'),
(3, 'Supplier Coklat', 'JL. Tuah Karya', '082114814439'),
(5, 'Supplier Gula', 'JL. Suka Karya', '082114814440');

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

--
-- Struktur dari tabel `user`
--

CREATE TABLE `user` (
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `level_user` int(3) NOT NULL,
  `foto` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`username`, `password`, `level_user`, `foto`) VALUES
('admin', 'admin', 1, ''),
('customer', 'customer', 3, ''),
('supplier', 'supplier', 2, '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `barang`
--
ALTER TABLE `barang`
  ADD PRIMARY KEY (`kode_barang`);

--
-- Indexes for table `pesan_barang`
--
ALTER TABLE `pesan_barang`
  ADD PRIMARY KEY (`kode_pesan_barang`);

--
-- Indexes for table `pesan_online`
--
ALTER TABLE `pesan_online`
  ADD PRIMARY KEY (`kode_pesan`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`supplier_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pesan_barang`
--
ALTER TABLE `pesan_barang`
  MODIFY `kode_pesan_barang` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `pesan_online`
--
ALTER TABLE `pesan_online`
  MODIFY `kode_pesan` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `supplier_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
/*!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 */;

buat file data.php dengan script berikut : copy ya jangan sampai terlewatkan:v

<?php
include "config/connect.php";

if ($_SESSION['leveluser']=='1'){
 if($_GET['dorayaki']=="profil"){
 include "modul/profil/profil.php";
 }
 if($_GET['dorayaki']=="struktur"){
 include "modul/profil/struktur.php";
 }
 if($_GET['dorayaki']=="bom"){
 include "modul/profil/bom.php";
 }
 if($_GET['dorayaki']=="peramalan"){
 include "modul/profil/peramalan.php";
 }
 if($_GET['dorayaki']=="agregat"){
 include "modul/profil/agregat.php";
 }
 if($_GET['dorayaki']=="mrp"){
 include "modul/profil/mrp.php";
 }
 if($_GET['dorayaki']=="barang"){
 include "modul/barang/barang.php";
 }
 if($_GET['dorayaki']=="supplier"){
 include "modul/supplier/supplier.php";
 }
 if($_GET['dorayaki']=="pemberitahuan"){
 include "modul/pemberitahuan/pemberitahuan_m.php";
 }
 if($_GET['dorayaki']=="pesanan"){
 include "modul/pesanan/pesanan_c.php";
 }
 if($_GET['dorayaki']=="pembelian"){
 include "modul/pembelian/pembelian.php";
 }
}
if ($_SESSION['leveluser']=='2'){
 if($_GET['dorayaki']=="pemberitahuan"){
 include "modul/pemberitahuan/pemberitahuan_s.php";
 }
 if($_GET['dorayaki']=="pesanan"){
 include "modul/pesanan/pesanan_m.php";
 }
}
if ($_SESSION['leveluser']=='3'){
 if($_GET['dorayaki']=="profil"){
 include "modul/profil/profil.php";
 }
 if($_GET['dorayaki']=="stok"){
 include "modul/stok/stok.php";
 }
 if($_GET['dorayaki']=="pesan"){
 include "modul/pesanan/pesan.php";
 }
 if($_GET['dorayaki']=="konfirmasi"){
 include "modul/pesanan/konfirmasi1.php";
 }
 if($_GET['dorayaki']=="konfirmasi1"){
 include "modul/pesanan/konfirmasi.php";
 }
 if($_GET['dorayaki']=="konfirmasigagal"){
 include "modul/pesanan/konfirmasigagal.php";
 }
}
?>

buat file tampil dengan script berikut :-) okee.

<!DOCTYPE html>
<?php 
session_start();
if (empty($_SESSION['username']) AND empty($_SESSION['password'])){
  echo "<script language='javascript' type='text/javascript'>
 alert('Anda Harus Login Terlebih Dahulu...!!!');
 </script>
 <meta http-equiv='refresh' content='0; url=index.php'>";  
}
else{
?>
<html lang="en">
 <head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE-edge">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
  <title>Celine Dorayaki</title>

<ul class="nav nav-pills nav-stacked" style="width:180px;" >
<li><a href="?dorayaki=profil"><span class="glyphicon glyphicon-home"> Profil</a></li>
<li class="treeview">
          
<li><a href="?dorayaki=barang"><span class="glyphicon glyphicon-tasks"> Barang</a></li>
<li><a href="?dorayaki=supplier"><span class="glyphicon glyphicon-user"> Supplier</a></li>
<li><a href="?dorayaki=pemberitahuan"><span class="glyphicon glyphicon-inbox"> Notifikasi</a></li>
<li><a href="?dorayaki=pesanan"><span class="glyphicon glyphicon-inbox"> Pesanan</a></li>
<li><a href="?dorayaki=pembelian"><span class="glyphicon glyphicon-shopping-cart"> Pembelian</a></li>
<li><a href="logout.php"><span class="glyphicon glyphicon-log-out"> Logout</a></li>
</ul>
<?php } ?>
 <?php
 if ($_SESSION['leveluser']=='2'){
 ?>
  <ul class="nav nav-pills nav-stacked" style="width:180px;">
<li><a href="?dorayaki=pemberitahuan"><span class="glyphicon glyphicon-inbox"> Notifikasi</a></li>
<li><a href="?dorayaki=pesanan"><span class="glyphicon glyphicon-inbox"> Pesanan</a></li>
<li><a href="logout.php"><span class="glyphicon glyphicon-log-out"> Logout</a></li>
</ul>
<?php } ?>
 <?php
 if ($_SESSION['leveluser']=='3'){
 ?>
  <ul class="nav nav-pills nav-stacked" style="width:180px;">
<li><a href="?dorayaki=profil"><span class="glyphicon glyphicon-home"> Profil</a></li>
<li><a href="?dorayaki=stok"><span class="glyphicon glyphicon-tasks"> Stok</a></li>
<li><a href="?dorayaki=pesan"><span class="glyphicon glyphicon-shopping-cart"> Pesan</a></li>
<li><a href="?dorayaki=konfirmasi1"><span class="glyphicon glyphicon-list-alt"> Pesan Dorayaki</a></li>
<li><a href="logout.php"><span class="glyphicon glyphicon-log-out"> Logout</a></li>
</ul>
<?php } ?>  
  </div>
<div class="col-sm-10">
   <?php include "data.php"; ?>
  </div>
</div>
</div>
</body>
</html>
<?php } ?>

mau tau selanjutnya klik link berikut ini :

source code sistem peminjaman alat berbasis web gratis part2

dan selanjutnya akan membahas script logout.php simple bgt jangan lupa koment kalau nggak tahu

tags:sourcode gratiss cara membuat sistem peminjaman alat berbasis web dengan php mysql di xampp