REFERENSI WEB 2

| Senin, 14 Januari 2019
Hallo blogger..
Disini saya akan berbagi mengenai project web yang sederhana dalam pengerjaan bahasa pemrograman WEB 2. yang isinya terdapat session login, dan crud. 

Bisa Langsung Download 

Udah termasuk Database.nya tinggal import saja. hehe OK :)

Komponen yang ada :
     1.    Koneksi.php
<?php
error_reporting(0); // disable error reporting
$host="localhost"; // isi dengan nama host server
$user_database="root"; // isi dengan username database
$password_database=""; // isi dengan password database

$koneksi_database=mysql_connect($host,$user_database,$password_database);

if ($koneksi_database) {
     mysql_select_db("uas_idam"); // isi dengan nama database yg dipakai
} else {
     mysql_error();
}
?>

     2.    Index.php
<style>
html, body {
       width : auto;
       height: auto;
       margin: 0;
}
#menu {
       background:#546e7a;
       font-weight:bold;  
       padding:5px 5px 5px 5px;
       padding-right:650px;
}

#menu li {
       font-weight:bold;
       font-size:14px;
       color:#FFF;
       display:inline;
       list-style:none;
       padding:10px 10px 10px 10px;
}

#menu li a {
       color:#FFF; 
       text-decoration: none;
}

#menu li a:hover {
       color:#eee; 
}

#konten {
       color:#000;
       padding:10px 10px 10px 10px;
}
</style>

<?php
session_start(); //MEMBUAT SESSION
error_reporting(0); // 0 = DISPLAY ERROR
?>
<html>
<head>
<title>UAS PRAKTIKUM</title>

</head>
<body>
<?php
include "koneksi.php";

       if ($_POST['submit']) {          
              $username=mysql_escape_string($_POST['username']);
              $password=mysql_escape_string($_POST['password']);
             
              $cek_database=mysql_fetch_array(mysql_query("select * from admin where username='".$username."' AND password='".md5($password)."' LIMIT 1"));
             
              if (!empty($cek_database['username'])||(!empty($cek_database['password']))) {

                    $_SESSION['id_admin']=$cek_database['id_admin'];
                    $_SESSION['nama_admin']=$cek_database['nama_admin'];
             
              } else {
                    $pesan_error="Username atau Password Salah :)";
              }
       }     
             
if ($_SESSION['id_admin']=="") { // jika admin belum login tampilkan halaman login
       ?>
    <form action="" method="post">
    <center><?=$pesan_error?></center>
           <table align="center">
              <tr>
                    <td width="100px">Username</td>
                    <td><input type="text" name="username" placeholder="input username anda" required /></td>
               </tr>
              <tr>
                    <td>Password</td>
                    <td><input type="password" name="password" placeholder="input password anda" required /></td>
               </tr>
               <tr>
                    <td></td>
                    <td><input type="submit" name="submit" value="Login" /></td>      
               </tr>
           </table>
    </form>
    <?php
      
} else {
?>

<!--  header -->

<!-- Menu -->
<div id="menu">
       <ul>
        <li><a href="user">Kelola Data</a></li>
        <li><a href="logout">Logout</a></li>
    </ul>
</div>

<div id="konten">
<?php
              $data_file = $_GET['folder'] .'/'.$_GET['file'] . '.php';
             
              if(file_exists($data_file)) {                        
                    if(empty($_SESSION['id_admin'])) {
                           include "konten/crud.php";
                    } else {
                           include $data_file;
                    }
              } else {
                    include "konten/crud.php";
              }

              ?>
</div>

<?php       
       }
?>
</body>
</html>
     
     3.    Crud.php
<h3>Insyaallah Nilainya A</h3>

Selamat Datang <b><?=$_SESSION['nama_admin']?></b> :)
Ini adalah halaman awal Uas Praktikum, SEMANGAT !!!

<?php
switch($_GET['fungsi']) {
default:
?>
<h3>DATA ADMIN</h3>

<a href="user-tambah">Tambah Data</a>
<br><br>
<table width="900px" border="1" cellpadding="0" cellspacing="0">
<thead>
     <tr>
    <th width="15px">No</th>
        <th>Nama Admin</th>
        <th>Username</th>
        <th>Password</th>
        <th width="50px">Edit</th>
        <th width="50px">Delete</th>
    </tr>
</thead>
<tbody>   
    <?php
    $admin=mysql_query("select * from admin order by nama_admin ASC");
    while ($dt=mysql_fetch_array($admin)) {
    $nomor++;
     ?>
    <tr>
    <td><?=$nomor?></td>
        <td><?=$dt['nama_admin']?></td>
        <td><?=$dt['username']?></td>
        <td><?=$dt['password']?></td>
        <td><a href="user-edit-<?=$dt['id_admin']?>">Ubah</a></td>
        <td><a href="user-delete-<?=$dt['id_admin']?>" onclick="javascript:return confirm('Anda yakin akan menghapus data ?');">Hapus</a></td>
    </tr>
    <?php
        }
     ?>
</tbody>   
</table>
<?php
break;

case "tambah";

if ($_POST['proses']) {
     if (empty($_POST['nama_admin'])||empty($_POST['username'])||empty($_POST['password'])) {
            $pesan_submit="Mohon Isi Data"; 
     } else {
            $proses=mysql_query("insert into admin values ('','$_POST[nama_admin]','$_POST[username]','".md5($_POST['password'])."')");
            if ($proses) {
            $pesan_submit="Data Berhasil Diinputkan, <a href='user'>Lihat admin</a>";
            } else {
            $pesan_submit="Server Sedang Offline"; 
            }     
     }     
}
?>

<h3>TAMBAH ADMIN</h3>
<h4><?=$pesan_submit?></h4>
<form action="" method="post">
    <table width="500px">
    <tr>
            <td width="120px">Nama admin</td><td><input type="text" name="nama_admin"></td>
        </tr>
    <tr>
            <td width="120px">Username</td><td><input type="text" name="username"></td>
        </tr>
    <tr>
            <td width="120px">Password</td><td><input type="password" name="password"></td>
        </tr>
        <tr>
            <td></td><td><input type="submit" name="proses" value="Proses"></td>
        </tr>
    </table>
</form>
<?php
break;

case "edit";

if ($_POST['proses']) {
     if (empty($_POST['nama_admin'])||empty($_POST['username'])) {
            $pesan_submit="Mohon Isi Data"; 
     } else {
            if (!empty($_POST['password'])) {
                   $proses=mysql_query("update admin SET nama_admin='$_POST[nama_admin]', username='$_POST[username]' where id_admin='$_GET[id]'");
            } else {
                   $proses=mysql_query("update admin SET nama_admin='$_POST[nama_admin]', username='$_POST[username]', password='".md5($_POST['password'])."' where id_admin='$_GET[id]'");
            }
            if ($proses) {
            $pesan_submit="Data Berhasil Diupdate,  <a href='user'>Lihat admin</a>";
            } else {
            $pesan_submit="Server Sedang Offline";
            }     
     }     
}
$dt=mysql_fetch_array(mysql_query("select * from admin where id_admin='$_GET[id]' LIMIT 1"));
?>

<h4><?=$pesan_submit?></h4>
<form action="" method="post">
<h3>EDIT admin</h3>
<hr>
    <table width="500px" border="5">
    <tr>
            <td width="120px">Nama admin</td><td><input type="text" name="nama_admin" value="<?=$dt['nama_admin']?>"></td>
        </tr>
    <tr>
            <td width="120px">Username</td><td><input type="text" name="username" value="<?=$dt['username']?>"></td>
        </tr>
    <tr>
            <td width="120px">Password</td><td><input type="password" name="password"> <i>Jika tidak diubah kosongkan</i></td>
        </tr>
        <tr>
            <td></td><td><input type="submit" name="proses" value="Proses"></td>
        </tr>
    </table>
</form>
<?php
break;

case "hapus";
$proses=mysql_query("delete from admin where id_admin='$_GET[id]'");
if ($proses) {
     ?>
    <script>
            alert("Data Berhasil dihapus");
            location="user";
     </script>
    <?php
} else {
     ?>
    <script>
            alert("Data Gagal dihapus");
            history.back(-1);
     </script>
    <?php
}
break;

}

     4.    Logout.php
<?php
session_destroy();
?>
<script>
location="home";
</script>

     5.    .htaccess
Options +FollowSymLinks
IndexIgnore */*

RewriteEngine on

DirectoryIndex home.html index.php

ErrorDocument 404 "<h1><center>Teu Aya Filena</center></h1>"
ErrorDocument 500 "<h1><center>Server Error</center></h1>"

RewriteRule ^home$ index.php?folder=konten&file=crud [L]

RewriteRule ^user$ index.php?folder=konten&file=crud [L]
RewriteRule ^user-tambah$ index.php?folder=konten&file=crud&fungsi=tambah [L]
RewriteRule ^user-edit-(.*)$ index.php?folder=konten&file=crud&fungsi=edit&id=$1 [L]
RewriteRule ^user-delete-([0-9]+)$ index.php?folder=konten&file=crud&fungsi=hapus&id=$1 [L]

RewriteRule ^logout$ index.php?folder=konten&file=logout [L]

Options +Indexes

# tanda '#' digunakan untuk memberi komentar


| 0 komentar

0 komentar:

Posting Komentar

Next → ← Prev
Rss: Top
▲Top▲