ruang_siswa.php - Paste

<?php

//asli ppdb
$konek = mysqli_connect("localhost","root","root","db_coba") or die ("Gagal konek ke server MySQL");

$nomor = 1;
$siswa_masuk_arr = [];
$tampil = "SELECT * FROM tbl_ruang ORDER BY id";
$hasil = mysqli_query($konek, $tampil);
while ($data = mysqli_fetch_array($hasil)) {
        echo '<strong>'.$data['nm_ruang'].'</strong> Kapasitas : '.$data['max'].' siswa';
        echo '<br>';
        $urutan = 1;
        $tampile = "SELECT * FROM tbl_siswa WHERE id NOT IN ('" . implode( "," , $siswa_masuk_arr) . "') ORDER BY id";
        $hasile = mysqli_query($konek, $tampile);
        while ($rows = mysqli_fetch_array($hasile)) {
                $siswa_masuk_arr[] = $rows['id'];
                $diurut = $urutan++;
                if($data['max'] >= $diurut) {
                        echo '<div class="row">
                        <div class="col-md-1">'.$nomor++.'</div><div class="col-md-1">'.$rows['nama'].'</div><div class="col-md-1"> ID-'.$rows['nopes'].'</div>
                        </div>';
                }
        }
}