siswa_cadangan.php

<?php

session_start();
include 'koneksi.php';

// fungsi cek sesi
if(isset($_SESSION['sesi'])){
    $header = "- Siswa Cadangan";
    include 'header.php';

?>

<!-- container -->
<div class="container">    
    <div class="card my-2">
        <h3 class="card-header text-center">Data Siswa Cadangan</h3>
        <div class="card-body container ">
            
            <!-- Tabel Siswa Cadangan -->
            <table class="table table-bordered nowrap" id="dataTable">
                <thead class="thead-dark">
                    <tr>
                        <th>NO</th>
                        <th>NISN</th>
                        <th>NAMA SISWA</th>
                        <th>ASAL SEKOLAH</th>
                        <th>STATUS PENERIMAAN</th>
                        <th>DETAIL SISWA</th>
                    </tr>
                </thead>
                <tbody>
                    
                <?php  

                    // mengambil data tabel pendaftaran dengan kondisi status Cadangan
                    $query = mysqli_query($db, "SELECT * FROM pendaftaran WHERE status='Cadangan'");
                    $data = mysqli_fetch_array($query);

                    // cek kolom dari pendaftaran
                    if(mysqli_num_rows($query) >0) {
                        $no = 1;
                        
                        // loop data tabel pendaftaran kondisi cadangan
                        do{

                ?>
                    <tr>
                        <td><?=$no++;?></td>
                        <td><?=$data['nisn'];?></td>
                        <td><?=$data['nama'];?></td>
                        <td><?=$data['asal_sekolah'];?></td>
                        <td><?=$data['status'];?></td>
                        <td>
                            <a role="button" name="submit" href="detail.php?id=<?=$data['id'];?>" class="btn btn-sm btn-secondary">Lihat Detail</a>
                        </td>
                    </tr>
                <?php 
                        }while($data = mysqli_fetch_assoc($query));
                    }else{

                        // jika false
                        echo "<tr><td colspan='7'><center>Belum ada data!</center></td></tr>";
                    }
                ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<?php

include 'footer.php';

} else {
    echo "<script>
            alert('Silahkan Login Terlebih Dahulu!');
            window.location = 'login.php';
        </script>";
}

?>