<?php $thisPage = "users"; ?>
<div class="row">
  <div class="col-md-12 panel-warning">
    <div class="content-box-header panel-heading">
      <div class="panel-title "><h3><b> Penilaian</b></h3></div>
      <div class="panel-options">
        <a href="#" data-rel="collapse" title="Refresh"><i class="glyphicon glyphicon-refresh" ></i></a>
      </div>
    </div><!-- content-box-header panel-heading -->
    <div class="content-box-large">
      <div class="panel-body">
        <form action="?page=simpan_nilai" method="POST">
          <table cellpadding="0" cellspacing="0" border="0" class="table  table-striped table-bordered datatable " id="tableuser">
            <thead>
              <tr>
                <th>No.</th>
                <th>Alternatif</th>
                <?php $q = mysqli_query($koneksi, "SELECT k.*
                                                    FROM detail_nilai d
                                                    INNER JOIN kriteria k ON k.id_krit=d.id_krit
                                                    GROUP BY k.kriteria
                                                    ORDER BY id_krit"); ?>
                <?php while ($row=mysqli_fetch_array($q)): ?>
                  <th><?php echo $row['kriteria']; ?></th>
                <?php endwhile; ?>
              </tr>
            </thead>
            <tbody>
              <?php $no = 1; ?>
              <?php $qu = mysqli_query($koneksi, "SELECT  p.nama from master_nilai m
                                                  INNER JOIN penari p ON p.id_penari=m.id_penari
                                                  ORDER BY m.id_penari;"); ?>
              <?php while ($row = mysqli_fetch_array($qu)): ?>
                <tr>
                  <td><?php echo $no; ?></td>
                  <td><?php echo $row['nama']; ?></td>
                  <?php $q = mysqli_query($koneksi, "SELECT *
                                                      FROM detail_nilai d, master_nilai m, penari p
                                                      WHERE d.id_nilai=m.id_nilai AND m.id_penari=p.id_penari AND p.nama='{$row['nama']}'
                                                      ORDER BY d.id_krit "); ?>
                  <?php while ($rows = mysqli_fetch_array($q)): ?>
                    <td><?php echo $rows['nilai_krit']; ?></td>
                  <?php endwhile; ?>
                </tr>
                <?php $no++; ?>
              <?php endwhile; ?>
            </tbody>
          </table>
          <div class="box-footer">
            <button type="submit" name="simpan" class="btn btn-success"><B>HITUNG</B>
          </div>
        </form><!-- .box-footer -->
      </div><!-- .panel-body -->
    </div><!-- .content-box-large -->
  </div><!-- col-md-12 panel-warning -->
</div><!-- .row -->