Untitled

<?php
// memanggil file koneksi ke database
require_once('db.php');
// membuat fungsi validasi
function validate($field, $message, &$errors) {
    if(empty($field)){
        $errors[] = $message;
    }
}

$id = $_GET['id'];

// mengecek apakah ada input dari form
$status = isset($_REQUEST['status']) ? $_REQUEST['status']: '';
$submit = isset($_REQUEST['submit']) ? $_REQUEST['submit']: '';

// array untuk menampung error
$errors = [];

if(!empty($submit)){
    validate($status, "Nama depan tidak boleh kosong", $errors);

    if(empty($errors)){

        $sql = "UPDATE pendaftaran SET status='{$status}' WHERE id = '{$id}'";

        if($conn->query($sql)){

            $msg = "<div class='alert alert-success'><strong>Sukses!</strong> Data berhasil diubah.</div>";

        } else {

            $msg = "<div class='alert alert-danger'><strong>Error:</strong> ".$conn->error."</div>";

        }
    }
}


// if(isset($id)){

$sql = "SELECT nama, status, id FROM pendaftaran WHERE id = '$id'";
$result = $conn->query($sql);

$cata_mapala = [];

$row = $result->fetch_assoc();
$id = $row['id'];
$nama = $row['nama'];
$status = $row['status'];

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Edit Pendaftaran Calon Anggota Mapala Raflesia Unindra</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
    <link rel="stylesheet" href="fontawesome/css/all.min.css">
</head>
<body>
    <div class="container-fluid">
        <div class="row mt-5">
            <div class="col-md-6 offset-md-3">
                <?php
                if(isset($msg)){
                    echo $msg;
                }
                ?>
                <div class="card">
                    <form action="edit_anggota.php?id=<?=$id?>" method="POST">
                        <div class="card-header">
                            Edit Data Calon Anggota: <strong><?=$nama?></strong>
                        </div>
                        <div class="card-body">

                            <div class="form-group">
                                <label for="">Status</label>
                                <select name="status" id="" class="form-control">
                                    <option <?= $status == "Calon Anggota"?'selected':''?> value="Calon Anggota">Calon Anggota</option>
                                    <option <?= $status == "Lulus"?'selected':''?> value="Lulus">Lulus</option>
                                    <option <?= $status == "Tidak Lulus"?'selected':''?> value="Tidak Lulus">Tidak Lulus</option>
                                </select>
                            </div>

                        </div>
                        <div class="card-footer">
                            <a href="/cata_mapala_unindra" class="btn btn-outline-info">Back</a>
                            <input type="submit" name="submit" class="btn btn-primary float-right" value="Update">
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script src="https://code.jquery.com/jquery.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>