Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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>
- <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
- ");
- while ($row=mysqli_fetch_array($q)){
- echo"
- <th>$row[kriteria]</th>
- ";}?>
- </tr>
- </thead>
- <tbody>
- <?php
- $no=1;
- $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;
- ");
- while ($row=mysqli_fetch_array($qu)){
- echo"
- <tr>
- <td>$no</td>
- <td>$row[nama]</td>
- ";
- $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
- ");
- while ($rows=mysqli_fetch_array($q)){
- echo"
- <td>$rows[nilai_krit]</td>
- </tr>";}
- $no++;}?>
- </tbody>
- </table>
- </div>
- <div class="box-footer">
- <button type="submit" name="simpan" class="btn btn-success"><B>HITUNG</B>
- </div>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <br>
Advertisement
Add Comment
Please, Sign In to add comment