<?php
$id1 = $_GET['id'];
$sql = $koneksi->query("SELECT * FROM tbl_data WHERE id='$id1'");
$tampil = $sql->fetch_assoc();
 ?>
<!-- Input -->
<div class="row clearfix">
    <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
        <div class="card">
            <div class="header">
                <h2>
                    UBAH DATA
                </h2>
            </div>
            <div class="body">
                <form method="POST">
                    <label for="">Nama</label>
                    <div class="form-group">
                        <div class="form-line">
                            <input type="text" class="form-control" name="nama" required="" pattern="[A-Za-z ]+"  value="<?php echo $tampil['nama']; ?>" />
                        </div>
                    </div>
                    <label for="">Username</label>
                    <div class="form-group">
                        <div class="form-line">
                            <input type="text" class="form-control" name="username" required="" value="<?php echo $tampil['username']; ?>" />
                        </div>
                    </div>
                    <label for="">Password</label>
                    <div class="form-group">
                        <div class="form-line">
                            <input type="password" class="form-control" name="password" required="" pattern="[a-zA-Z0-9]+"  value="<?php echo $tampil['password']; ?>" />
                        </div>
                    </div>
                    <label for="">Email</label>
                    <div class="form-group">
                        <div class="form-line">
                            <input type="email" class="form-control" name="email" required="" value="<?php echo $tampil['email']; ?>" />
                        </div>
                    </div>
                    <input type="submit" name="simpan" value="Simpan" class="btn btn-primary">
                </form>
            </div>
        </div>
    </div>
</div>

<?php

if (isset($_POST['simpan'])) {
    $nama = $_POST['nama'];
    $username = $_POST['username'];
    $password = $_POST['password'];
    $email = $_POST['email'];

    $sql1 = $koneksi->query("UPDATE tbl_data SET nama='$nama', username='$username', password='$password', email='$email' WHERE id='$id1'");
    if ($sql1){
        ?>
            <script type="text/javascript">
                alert("Data Berhasil Diubah");
                window.location.href="?page=data";
            </script>
        <?php
    }
}
?>