user-edit.php

<?php
include 'koneksi.php';

$id = (int) $_GET['id'];
$data = $db->query("SELECT * from users WHERE iduser='{$id}'")->fetch_assoc();

if(isset($_POST) && !empty($_POST)){

    $res = $db->prepare("UPDATE users SET nama=?,gender=?,email=?,nohp=?,divisi=?,alamat=? WHERE iduser=?");
    $res->bind_param('sssssss', $_POST['nama'], $_POST['gender'], $_POST['email'], $_POST['nohp'], $_POST['divisi'], $_POST['alamat'], $id);
    if($res->execute()){
        echo "<script>alert('Data berhasil diperbaharui');location.href='web.php?p=user';</script>";
    }else{
        echo '<p>Data gagal disimpan</p>';
    }
}
?>
<div class="content">
    <h1>Edit Data User</h1>
    <form action="" method="post">
    <table>
    <tr>
        <td>Nama</td>
        <td><input type="text" name="nama" placeholder="Nama" value="<?=$data['nama']?>" required /></td>
    </tr>
    <tr>
        <td>Jenis Kelamin</td>
        <td>
            <label><input type="radio" name="gender" value="L"<?=$data['gender']=='L' ? ' checked' : '' ?> required /> Laki-laki</label>
            <label><input type="radio" name="gender" value="P"<?=$data['gender']=='P' ? ' checked' : '' ?> required /> Perempuan</label>
        </td>
    </tr>
    <tr>
        <td>E-mail</td>
        <td><input type="email" name="email" placeholder="E-mail" value="<?=$data['email']?>" required /></td>
    </tr>
    <tr>
        <td>No HP</td>
        <td><input type="tel" name="nohp" placeholder="No HP" value="<?=$data['nohp']?>" required /></td>
    </tr>
    <tr>
        <td>Divisi</td>
        <td><select name="divisi" required><?php
            $arrDivisi = ['Divisi A','Divisi B','Divisi C'];
            foreach($arrDivisi as $divisi){
                $sel = $divisi==$data['divisi'] ? ' selected' : '';
                echo "<option value=\"$divisi\"$sel>$divisi</option>";
            }
            ?>
        </select></td>
    </tr>
    <tr>
        <td>Alamat</td>
        <td><textarea name="alamat" cols="50" rows="3" placeholder="Alamat" required><?=$data['alamat']?></textarea></td>
    </tr>
    <tr>
        <td></td>
        <td>
            <input type="button" onclick="history.back()" value="Kembali" />
            <input type="submit" value="Simpan" />
        </td>
    </tr>
    </table>
    </form>
</div>