Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
- //phpdanmysql.com - Membuat halaman kompirmasi pendaftar login
- session_start();
- include "koneksi.php";
- if (isset($_SESSION['level']) && isset($_SESSION['username']))
- {
- if ($_SESSION['level'] == "admin")
- {
- if(isset($_POST['simpan'])){
- $username=$_POST['username'];
- $password=md5($_POST['password']);
- $password2=md5($_POST['password2']);
- $nama_lengkap=$_POST['nama_lengkap'];
- $email=$_POST['email'];
- $telp_hp=$_POST['telp_hp'];
- $level=$_POST['level'];
- if(empty($username)||empty($password)||empty($password2)||empty($nama_lengkap)||empty($email)||empty($telp_hp)||empty($level))
- {
- echo "<script type='text/javascript'>
- onload =function(){
- alert('Data belum lengkap, silahkan periksa kembali isian form!');
- }
- </script>";
- }else{
- $a="insert into user(username,password,nama_lengkap,email,telp_hp,level)values('$username','$password','$nama_lengkap','$email','$telp_hp','$level')";
- $b=mysqli_query($a);
- if($b){
- echo "<script type='text/javascript'>
- onload =function(){
- alert('Data berhasil disimpan!');
- }
- </script>";
- }else{
- echo "<script type='text/javascript'>
- onload =function(){
- alert('Data gagal disimpan!');
- }
- </script>";
- }
- }
- }
- $username=$_GET['username'];
- $sql="select * from user where username='$username'";
- $query= mysqli_query($sql);
- $baris= mysqli_fetch_array($conn,$query);
- if(isset($_POST['Edit'])){
- $password=md5($_POST['password']);
- $nama_lengkap=$_POST['nama_lengkap'];
- $email=$_POST['email'];
- $telp_hp=$_POST['telp_hp'];
- $level=$_POST['level'];
- if(strlen($password)>0){
- new mysqli_query("update user set password='$password' where username='$username'");
- }
- $a="Update user set nama_lengkap='$nama_lengkap',email='$email',telp_hp='$telp_hp',level='$level' where username='$username'";
- $b=new mysqli_query($a);
- if($b){
- header("location:user.php");
- }else{
- echo "<script type='text/javascript'>
- onload =function(){
- alert('User gagal diubah!');
- }
- </script>";
- }
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <style type="text/css">
- body{
- font-family: arial;
- font-size: 14 px;
- }
- #canvas{
- widht:960px;
- margin:0 auto;
- border : 1px solid silver;
- }
- #header{
- font-size: 28px;
- color: #fff;
- padding: 20px;
- text-align : center;
- background-color: #00af0c;
- }
- #menu{
- background-color: #00c767;
- }
- #menu ul {
- list-style: none;
- margin: 0;
- padding: 0;
- }
- #menu ul li.utama{
- display: inline-table;
- }
- #menu ul li:hover{
- background-color:#33b400;
- }
- #menu ul li a{
- display: block;
- text-decoration: none;
- line-height: 40px;
- padding: 0 10px;
- color: #fff;
- }
- .utama ul{
- display: none;
- position: absolute;
- z-index: 2;
- }
- .utama:hover ul{
- display: block;
- }
- .utama ul li{
- display: block;
- background-color: #00c767;
- widht: 140px;
- }
- #isi{
- color: #0a9200;
- padding: 20px;font-family: arial;
- line-height: 25px;
- padding: 20px;
- background-color: #f2f6fa;
- }
- #footer{
- text-align : center;
- padding: 20px;
- background-color: #ccc;
- }
- </style>
- <title>Koperasi Semoga jaya</title>
- </head>
- <body>
- <div id="canvas">
- <div id="header">
- Koperasi Semoga Jaya
- </div>
- <div id="menu">
- <ul>
- <li class="utama"><a href="home.php"> Beranda </a></li>
- <li class="utama"><a href=""> Cek Data </a>
- <ul>
- <li><a href="datapembeli.php"> Pembelian </a></li>
- </ul>
- <li class="utama" style="float:right;"><a href="logout.php"> <font color="#e70026">Logout </font> </a></li>
- </ul>
- </div>
- <table width="644" border="0" align="center" cellpadding="1" cellspacing="0">
- <tr>
- <td width="549"><table width="598" border="0" align="center">
- <tr>
- <td width="518"><div align="center">
- <h2><strong>KELOLA USER
- </strong></h2>
- </div>
- <form action="" method="post" name="form1" id="form1">
- <table width="553" border="0" align="center" cellpadding="1" cellspacing="0">
- <tr>
- <td width="149">Username</td>
- <td width="400"><label><?php if(!$_GET['username']){
- echo "<input name='username' type='text' id='username' size='20'>";
- }else{
- echo "<b>".$baris['username']."</b>";
- }
- ?>
- </label></td>
- </tr>
- <tr>
- <td>Password</td>
- <td><label>
- <input name="password" type="password" id="password" size="25" />
- </label>
- <?php
- if($_GET['username']){
- echo "<br><font color='red'>Silahkan Ubah Password</font>";
- }
- ?> </td>
- </tr>
- <tr>
- <td>Nama Lengkap </td>
- <td><label>
- <input name="nama_lengkap" type="text" id="nama_lengkap" size="35" value="<?php echo $baris['nama_lengkap'];?>"/>
- </label></td>
- </tr>
- <tr>
- <td>Email</td>
- <td><label>
- <input name="email" type="text" id="email" size="35" value="<?php echo $baris['email'];?>"/>
- </label></td>
- </tr>
- <tr>
- <td>Telpon/HP</td>
- <td><label>
- <input name="telp_hp" type="text" id="telp_hp" size="15" value="<?php echo $baris['telp_hp'];?>"/>
- </label></td>
- </tr>
- <tr>
- <td>Level User </td>
- <td><label>
- <select name="level" id="level">
- <option value="admin" <?php if($baris['level']=="admin"){ echo "selected";}?>>Administrator</option>
- <option value="anggota" <?php if($baris['level']=="anggota"){ echo "selected";}?>>Anggota</option>
- </select>
- </label></td>
- </tr>
- <tr>
- </tr>
- <tr>
- <td> </td>
- <td><?php if(!$_GET['username']){
- //bila mau tambah data yang tampil tombol simpan
- echo "<input name=\"simpan\" type=\"submit\" id=\"simpan\" value=\"Simpan\" /> ";
- echo "<input name=\"batal\" type=\"reset\" id=\"batal\" value=\"Batal\" />";
- } else {
- //Apabila mau edit yg tampil tombol edit dan hapus
- echo "<input name=\"Edit\" type=\"submit\" id=\"edit\" value=\"Edit\" />";
- } ?> </tr>
- </table>
- </form>
- <p align="center"> </p>
- <p align="center"> </p></td>
- </tr>
- </table>
- <h3 align="center"> </h3>
- <h3 align="center">Tabel User </h3>
- <table width="690" border="1" align="center" cellspacing="0">
- <tr bgcolor="#FFFF99">
- <td width="50"><div align="center"><strong>No</strong></div></td>
- <td width="100"><div align="center"><strong>Username</strong></div></td>
- <td width="150"><div align="center"><strong>Nama Lengkap</strong></div></td>
- <td width="150"><div align="center"><strong>Email</strong></div></td>
- <td width="100"><div align="center"><strong>Telephon/HP</strong></div></td>
- <td width="50"><div align="center"><strong>Level</strong></div></td>
- <td colspan="2" width="90"><div align="center"><strong>Aksi</strong></div></td>
- </tr>
- <?php
- $hal = $_GET[hal];
- // jika page default nya 1
- if(!isset($_GET['hal'])){
- $halaman = 1;
- } else {
- $halaman = $_GET['hal'];
- }
- //tentukan jumlah data setiap halaman
- $hal_maksimum =10;
- // halaman di kali MAX jumlah item per halaman dikurangi MAX jumlah item per halaman
- $mulai = (($halaman * $hal_maksimum) - $hal_maksimum);
- $sql="select * from user order by level ASC LIMIT $mulai, $hal_maksimum";
- $query=mysqli_query($conn,$sql);
- $no=1;
- while($data= mysqli_fetch_array($query)){
- ?>
- <tr>
- <td><div align="center"><?php echo $no; ?></div></td>
- <td><?php echo $data['username']; ?></td>
- <td><?php echo $data['nama_lengkap']; ?></td>
- <td><?php echo $data['email']; ?></td>
- <td><?php echo $data['telp_hp']; ?></td>
- <td><?php echo $data['level']; ?></td>
- <td><div align="center"><a href="user.php?username=<?php echo $data['username']; ?>"><img src="../gambar/edit.png" width="20" height="20" /></a><a href="javascript:if(confirm('Anda yakin akan menghapus data ini??')){document.location='hapususer.php?username=<?php echo $data['username']; ?>';}"><img src="../gambar/hapus.jpg" width="20" height="20" /></a> </div></td>
- </tr>
- <?php
- $no++;
- }?>
- </table>
- <?php
- $total= new mysqli_result(mysqli_query($conn,"SELECT COUNT(*) as jumlah FROM user"),1);
- $jumlah_halaman = ceil($total / $hal_maksimum);
- // bangun jumlah hiperlink halaman
- echo "<center>Halaman<br />";
- // bangun Previous link
- if($hal > 1){
- $sebelum = ($halaman - 1);
- echo "<a href=$_SERVER[PHP_SELF]?hal=$sebelum title=Sebelumnya>Prev</a>
- ";
- }
- for($i = 1; $i <= $jumlah_halaman; $i++){
- if(($hal) == $i){
- echo "$i ";
- } else {
- echo "<a href=$_SERVER[PHP_SELF]?hal=$i>$i</a> ";
- }
- }
- // bangun Next link
- if($hal < $jumlah_halaman){
- $selanjutnya = ($halaman + 1);
- echo "<a href=$_SERVER[PHP_SELF]?hal=$selanjutnya title=Selanjutnya>Next</a>";
- }
- echo "</center>";
- ?>
- <p> </p>
- </td>
- </tr>
- </table>
- <div ></div>
- </td>
- <td valign="" background=""><img src="" alt="" width="" height="" border="0"></td>
- <td width="50%" background=""><img src="" width="1" height="1" alt="" border="0"></td>
- </tr>
- </table>
- </body>
- </html>
- <?php
- }
- else
- {
- // jika levelnya bukan admin, tampilkan pesan
- echo "<script>alert('Maaf.. Anda bukan admin');javascript:history.go(-1);</script>";
- }
- }
- else
- {
- echo "<script>alert('Silakan login!!');javascript:history.go(-1);</script>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement