edit.php

<?php
require_once 'konek.php';

$uname   = isset($uname)   ? $uname   : null;
$pwd     = isset($pwd)     ? $pwd     : null;
$u_akses = isset($u_akses) ? $u_akses : null;

$id = isset($_GET['id']) ? $_GET['id'] : null;
$uid = $id;
$alert = '';

if(isset($_POST['edit'])) {
  $username   = isset($_POST['username'])   ? $_POST['username']   : null;
  $password   = isset($_POST['password'])   ? $_POST['password']   : null;
  $user_akses = isset($_POST['user_akses']) ? $_POST['user_akses'] : null;

  if(empty($username) || empty($password) || empty($user_akses)) {
    $alert = '<b style="color: red;">Harap isi semua formulir!</b>';
  } else {
    $username   = trim(htmlentities(stripslashes(mysql_real_escape_string($username))));
    $password   = trim(htmlentities(stripslashes(mysql_real_escape_string($password))));
    $user_akses = trim(htmlentities(stripslashes(mysql_real_escape_string($user_akses))));

    $query1 = "update anggota set username = '" .$username. "' where user_id = '" .$uid. "'";
    $query2 = "update anggota set password = '" .$password. "' where user_id = '" .$uid. "'";
    $query3 = "update anggota set user_akses = '" .$user_akses. "' where user_id = '" .$uid. "'";
    $hasil  = mysql_query($query1);
    $hasil .= mysql_query($query2);
    $hasil .= mysql_query($query2);
    if($hasil) {
      $alert = '<b style="color: green;">Data berhasil diedit!</b>';
    }
  }
}

$q = "select * from anggota where user_id ='" .$uid. "'";
$h = mysql_query($q);
if(mysql_num_rows($h) > 0) {
  while($data = mysql_fetch_array($h)) {
    $uname   = $data['username'];
    $pwd     = $data['password'];
    $u_akses = $data['user_akses'];
    $data++;
  }

  if($u_akses == 'User') {
    $opsi = '
      <option value="User" selected="selected">User</option>
      <option value="Admin">Admin</option>';
  } else {
    $opsi = '
      <option value="Admin" selected="selected">Admin</option>
      <option value="User">User</option>';
  }
}


mysql_close($konek);

 ?>


 <!DOCTYPE html>
 <html>
   <head>
     <meta charset="utf-8">
     <title>Tambah Anggota</title>
 <style>
 table, th, td {
     border: 1px solid black;
     border-collapse: collapse;
 }
 th, td {
     padding: 5px;
     text-align: left;
 }

 div {
    width: 100%;
    padding: 4px 4px 4px 4px;
    margin: 3px 3px 8px 3px;
    font-size: 36px;
 }
 </style>
   </head>
   <body>
     <table style="width:100%">
       <div>
         <img src="fasilkom.jpg" width="48px" height="48px" alt="Logo" /> Edit Anggota
       </div>
    <br><br>
    <?php echo $alert; ?>
    <br>
    <br>
    <form action="edit.php" method="post">
      <span>Username:</span>
      <input type="text" name="username" value="<?php echo $uname; ?>"><br><br>
      <span>Password:</span>
      <input type="password" name="password" value="<?php echo $pwd; ?>"><br><br>
      User Akses: <select name="user_akses"><br><br>
        <?php echo $opsi; ?>
      </select><br><br>
      <input type="submit" name="edit" value="Simpan" style="color: white; background: green; border: 1px solid black; text-decoration: none;">
      <input type="reset" name="reset" value="Reset" style="color: white; background: blue; border: 1px solid black; text-decoration: none;">
    </form>
    <br>
    <br>
    <a style="text-decoration: none; background: grey;" href="index.php"> &laquo;&laquo; Kembali ke depan</a>
  </body>
</html>