View difference between Paste ID: ybE7fmSi and KDTVwaRD
SHOW: | | - or go back to the newest paste.
1-
<?php $thisPage = "users";
1+
<?php $thisPage = "users"; ?>
2-
?>
2+
<div class="row">
3-
		  	<div class="row">
3+
  <div class="col-md-12 panel-warning">
4-
		  		<div class="col-md-12 panel-warning">
4+
    <div class="content-box-header panel-heading">
5-
		  			<div class="content-box-header panel-heading">
5+
      <div class="panel-title "><h3><b> Penilaian</b></h3></div>
6-
	  					<div class="panel-title "><h3><b> Penilaian</b></h3></div>
6+
      <div class="panel-options">
7-
						<div class="panel-options">
7+
        <a href="#" data-rel="collapse" title="Refresh"><i class="glyphicon glyphicon-refresh" ></i></a>
8-
							<a href="#" data-rel="collapse" title="Refresh"><i class="glyphicon glyphicon-refresh" ></i></a>
8+
      </div>
9-
							
9+
    </div><!-- content-box-header panel-heading -->
10-
						</div>
10+
    <div class="content-box-large">
11-
		  			</div>
11+
      <div class="panel-body">
12-
		  			<div class="content-box-large">
12+
        <form action="?page=simpan_nilai" method="POST">
13-
					
13+
          <table cellpadding="0" cellspacing="0" border="0" class="table  table-striped table-bordered datatable " id="tableuser">
14-
			  			<div class="panel-body">
14+
            <thead>
15-
					<form action="?page=simpan_nilai" method="POST">
15+
              <tr>
16-
  					<table cellpadding="0" cellspacing="0" border="0" class="table  table-striped table-bordered datatable " id="tableuser">
16+
                <th>No.</th>
17-
						<thead>
17+
                <th>Alternatif</th>
18-
							<tr>
18+
                <?php $q = mysqli_query($koneksi, "SELECT k.*
19-
								<th>No.</th>
19+
                                                    FROM detail_nilai d
20-
								<th>Alternatif</th>
20+
                                                    INNER JOIN kriteria k ON k.id_krit=d.id_krit
21-
								<?php
21+
                                                    GROUP BY k.kriteria
22-
								$q=mysqli_query($koneksi,"select k.*
22+
                                                    ORDER BY id_krit"); ?>
23-
								from detail_nilai d
23+
                <?php while ($row=mysqli_fetch_array($q)): ?>
24-
								inner join kriteria k on k.id_krit=d.id_krit
24+
                  <th><?php echo $row['kriteria']; ?></th>
25-
								group by k.kriteria
25+
                <?php endwhile; ?>
26-
								order by id_krit
26+
              </tr>
27-
							");
27+
            </thead>
28-
								while ($row=mysqli_fetch_array($q)){
28+
            <tbody>
29-
								echo"
29+
              <?php $no = 1; ?>
30-
								<th>$row[kriteria]</th>
30+
              <?php $qu = mysqli_query($koneksi, "SELECT  p.nama from master_nilai m
31-
								";}?>
31+
                                                  INNER JOIN penari p ON p.id_penari=m.id_penari
32-
							</tr>
32+
                                                  ORDER BY m.id_penari;"); ?>
33-
						</thead>
33+
              <?php while ($row = mysqli_fetch_array($qu)): ?>
34-
						<tbody>
34+
                <tr>
35-
						<?php 
35+
                  <td><?php echo $no; ?></td>
36-
						$no=1;					
36+
                  <td><?php echo $row['nama']; ?></td>
37-
						$qu=mysqli_query($koneksi,"select  p.nama from master_nilai m
37+
                  <?php $q = mysqli_query($koneksi, "SELECT * 
38-
						inner join penari p on p.id_penari=m.id_penari
38+
                                                      FROM detail_nilai d, master_nilai m, penari p
39-
						order by m.id_penari;
39+
                                                      WHERE d.id_nilai=m.id_nilai AND m.id_penari=p.id_penari AND p.nama='{$row['nama']}'
40-
							");
40+
                                                      ORDER BY d.id_krit "); ?>
41-
							
41+
                  <?php while ($rows = mysqli_fetch_array($q)): ?>
42-
								while ($row=mysqli_fetch_array($qu)){
42+
                    <td><?php echo $rows['nilai_krit']; ?></td>
43-
						echo"
43+
                  <?php endwhile; ?>
44-
							<tr>
44+
                </tr>
45-
								<td>$no</td>
45+
                <?php $no++; ?>
46-
							<td>$row[nama]</td>
46+
              <?php endwhile; ?>
47-
							";
47+
            </tbody>
48-
							$q=mysqli_query($koneksi,"select * 
48+
          </table>
49-
							from detail_nilai d, master_nilai m, penari p
49+
          <div class="box-footer">
50-
							where d.id_nilai=m.id_nilai and m.id_penari=p.id_penari and p.nama='$row[nama]' order by d.id_krit
50+
            <button type="submit" name="simpan" class="btn btn-success"><B>HITUNG</B>
51-
							");
51+
          </div>
52-
							while ($rows=mysqli_fetch_array($q)){
52+
        </form><!-- .box-footer -->
53-
							echo"
53+
      </div><!-- .panel-body -->
54-
								<td>$rows[nilai_krit]</td>
54+
    </div><!-- .content-box-large -->
55-
							</tr>";}
55+
  </div><!-- col-md-12 panel-warning -->
56-
								$no++;}?>
56+
</div><!-- .row -->