<?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 -->
Comments