edit.php

<?php
    session_start();
    include ("../config/koneksi.php");

    $aksi = $_GET['aksi'];

    if ($aksi == "edit_admin") {
        $id_admin       = $_POST['id_admin'];
        $fullname       = $_POST['fullname'];
        $username       = $_POST['username'];
        $password       = $_POST['password'];
        $password2      = md5($password);
        $pass_new       = $_POST['password_baru'];
        $pass_conf      = $_POST['password_conf'];
        $pass_conf_2    = md5($pass_conf);
        $level          = $_POST['level'];
        $status         = $_POST['status'];

        $query          = mysqli_query($koneksi,("SELECT * FROM tb_admin WHERE id_admin = '$id_admin'"));
        $row            = mysqli_fetch_array($query);

        if ($password == "") {
            mysqli_query($koneksi,("UPDATE tb_admin SET fullname = '$fullname', username = '$username',
                                           level = '$level', status = '$status'
                                           WHERE id_admin = '$id_admin'")) or die(mysql_errno());
            echo "<script language='javascript'>alert('update berhasil')</script>";
            echo "<script language='javascript'>window.location = '../administrator'</script>";
        } else if ($password2 == $row['password']) {
            if ($pass_new == "") {
                mysqli_query($koneksi,("UPDATE tb_admin SET fullname = '$fullname', username = '$username',
                                               level = '$level', status = '$status'
                                               WHERE id_admin = '$id_admin'")) or die(mysql_errno());
                echo "<script language='javascript'>alert('update berhasil')</script>";
                echo "<script language='javascript'>window.location = '../administrator'</script>";
            } else if ($pass_conf == $pass_new) {
                mysqli_query($koneksi,("UPDATE tb_admin SET fullname = '$fullname', username = '$username',
                                               password = '$pass_conf_2', level = '$level', status = '$status'
                                               WHERE id_admin = '$id_admin'")) or die(mysql_errno());
                echo "<script language='javascript'>alert('update berhasil')</script>";
                echo "<script language='javascript'>window.location = '../administrator'</script>";
            }else {
                echo "<script language='javascript'>alert('update gagal')</script>";
                echo "<script language='javascript'>window.location = '../administrator'</script>";
            }
        }
        else{
            echo "<script language='javascript'>alert('update gagal')</script>";
            echo "<script language='javascript'>window.location = '../administrator'</script>";
        }
    }

    else if ($aksi == "edit_anggota") {
        $id_agt         = $_POST['id_agt'];
        $no_anggota     = $_POST['no_anggota'];
        $nama           = $_POST['nama'];
        $perusahaan     = $_POST['nama_perusahaan'];
        $alamat_pr      = $_POST['alamat_perusahaan'];
        $telpon_pr      = $_POST['telpon_perusahaan'];
        $fax            = $_POST['fax_perusahaan'];
        $email_pr       = $_POST['email_perusahaan'];
        $alamat_rm      = $_POST['alamat_rumah'];
        $hp             = $_POST['handphone'];
        $email          = $_POST['email'];

        $query          = mysqli_query($koneksi,("SELECT * FROM tb_anggota WHERE no_anggota = '$no_anggota'"));
        $row            = mysqli_num_rows($query);

        if ($row > 0) {
            mysqli_query($koneksi,("UPDATE tb_anggota SET nama = '$nama', nama_perusahaan = '$perusahaan',
                                           alamat_perusahaan = '$alamat_pr', telpon_perusahaan = '$telpon_pr', fax = '$fax',
                                           email_perusahaan = '$email_pr', alamat_rumah = '$alamat_rm', handphone = '$hp', email = '$email'
                                           WHERE id_agt = '$id_agt'")) or die(mysql_errno());
            echo "<script>alert('Nomer Anggota $no_anggota telah terdaftar')</script>";
            echo "<script>window.location = '../anggota'</script>";
        }else{
            mysqli_query($koneksi,("UPDATE tb_anggota SET no_anggota = '$no_anggota', nama = '$nama', nama_perusahaan = '$perusahaan',
                                           alamat_perusahaan = '$alamat_pr', telpon_perusahaan = '$telpon_pr', fax = '$fax',
                                           email_perusahaan = '$email_pr', alamat_rumah = '$alamat_rm', handphone = '$hp', email = '$email'
                                           WHERE id_agt = '$id_agt'")) or die(mysql_errno());

            echo "<script>alert('update berhasil')</script>";
            echo "<script>window.location = '../anggota'</script>";
        }
    }
?>