<?php
include "../koneksi.php";

$data = mysqli_query($link,"SELECT * FROM tb_latihan2");

if(!$data){
    die("Query Error: " . mysqli_error($link));
}
?>

<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.8/dist/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.8/dist/js/bootstrap.bundle.min.js"></script>
</head>

<body>
<div class="container mt-4">
    <h2 align="center">Data Guru dan Tenaga Kependidikan</h2>

    <table class="table table-bordered">
        <tr>
            <td>
                <button class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#mytambah">
                    Tambah Data
                </button>
            </td>
            <td align="right">
                <a href="cekdata.php" class="btn btn-success">Cetak Data</a>
            </td>
        </tr>
    </table>

    <table class="table table-bordered table-striped">
        <tr>
            <th>No</th>
            <th>NUPTK</th>
            <th>Nama</th>
            <th>JK</th>
            <th>Tmp Lahir</th>
            <th>Tgl Lahir</th>
            <th>Status</th>
            <th>Alamat</th>
            <th>Kelurahan</th>
            <th>Kecamatan</th>
            <th>Kab/Kota</th>
            <th>Provinsi</th>
            <th>Kode Pos</th>
            <th>No HP</th>
            <th>Tgl Masuk</th>
            <th>Aksi</th>
        </tr>

        <?php
        $no = 1;
        while($dt = mysqli_fetch_assoc($data)){
        ?>
        <tr>
            <td><?= $no++; ?></td>
            <td><?= $dt['nuptk']; ?></td>
            <td><?= $dt['nama']; ?></td>
            <td><?= $dt['jns_kelamin']; ?></td>
            <td><?= $dt['tmp_lahir']; ?></td>
            <td><?= $dt['tgl_lahir']; ?></td>
            <td><?= $dt['status']; ?></td>
            <td><?= $dt['alamat']; ?></td>
            <td><?= $dt['kelurahan']; ?></td>
            <td><?= $dt['kecamatan']; ?></td>
            <td><?= $dt['kab_kota']; ?></td>
            <td><?= $dt['provinsi']; ?></td>
            <td><?= $dt['kode_pos']; ?></td>
            <td><?= $dt['no_hp']; ?></td>
            <td><?= $dt['tgl_masuk']; ?></td>
            <td>
                <a href="hapusdata.php?nuptk=<?= $dt['nuptk']; ?>" 
                   onclick="return confirm('Yakin ingin menghapus?')" 
                   class="btn btn-danger btn-sm">
                   Hapus
                </a>
            </td>
        </tr>
        <?php } ?>
    </table>
</div>
</body>
</html>