Pencarian

<h1 class="page-header"> <span class="glyphicon glyphicon-book"></span> &nbsp Daftar Nilai Ujian</h1>
  <div class="row placeholders">
  <form class="navbar-form navbar-left " action="" method="post" >
  <div class="form-group">
   <select class="form-control" name="sesi">
                    <option> -- Try-Out Ke -- </option>
                    <?php
                    $sql ="SELECT DISTINCT sesi FROM  `tbl_nil_ujian` ";
                    $query = mysql_query($sql);
                    while($row = mysql_fetch_array($query)){
                    ?>
                        <option value="<?php echo $row[0]?>"><?php echo $row[0]?></option>
                  <?php
                    }
                  ?>
    </select>
  </div>
   <div class="form-group">
   <select class="form-control" name="jurusan">
                    <option> -- Jurusan -- </option>
                    <?php
                    $sql ="SELECT DISTINCT jurusan FROM  `tbl_siswa`  ";
                    $query = mysql_query($sql);
                    while($row = mysql_fetch_array($query)){
                    ?>
                        <option value="<?php echo $row[0]?>"><?php echo $row[0]?></option>
                  <?php
                    }
                  ?>
    </select>
  </div>
  <div class="form-group">
   <select class="form-control" name="kelas">
                    <option> -- Kelas -- </option>
                    <?php
                    $sql ="SELECT DISTINCT kelas FROM  `tbl_siswa` ";
                    $query = mysql_query($sql);
                    while($row = mysql_fetch_array($query)){
                    ?>
                        <option value="<?php echo $row[0]?>"><?php echo $row[0]?></option>
                  <?php
                    }
                  ?>
    </select>
  </div>
  <button type="submit" name="submit" class="glyphicon glyphicon-search btn btn-primary btn-large"></button>
</form>
<br/><br/><br/><br/><br/><br/>
 <?php
 if(isset($_POST['submit'])){

    $jurusan    = $_POST['jurusan'];
    $kelas      = $_POST['kelas'];
    $sesi       = $_POST['sesi'];

    $sql1   = "SELECT  `nama` , COUNT( DISTINCT s.id_siswa ) FROM  `tbl_nil_ujian` AS n LEFT JOIN  `tbl_siswa` AS s ON n.id_siswa = s.id_siswa WHERE `kelas` ='$kelas'";
    $query1 = mysql_query ($sql1);
    $row1   = mysql_fetch_array($query1);
    $siswa  = $row1[1];
    $nama   = $row1[0];

    for ($x =1; $x <= $siswa; $x++) {
?>
<span class="label label-info">Try-Out Ke <?php echo $sesi = $_POST['sesi']; ?></span> <span class="label label-info">Nama &nbsp : &nbsp <?php echo $row1['nama'] ?></span>
<table class="table table-striped  table-hover "  style="text-align:center;">
    <thead>

        <tr>
            <th class="col-sm-1"><center>No</center></th>
            <th class="col-sm-3"><center>Tangal Ujian</center></th>
            <th class="col-sm-2"><center>Mata Pelajaran</center></th>
            <th class="col-sm-2"><center>Nilai Ujian</center></th>
        </tr>
    </thead>
    <tbody>
<?php
    $sql    = "SELECT * FROM  `tbl_nil_ujian` AS n LEFT JOIN  `tbl_siswa` AS s ON n.id_siswa = s.id_siswa  WHERE `sesi` ='$sesi' and `nama` = '$nama' and `kelas` ='$kelas' ";
    $query  =mysql_query($sql);
    $no=0;
    while($row=mysql_fetch_array($query)){
    $no++;
?>
    <tr>
        <td><?php echo $no;?></td>
        <td><?php echo $row[2]?></td>
        <td><?php echo $row[3]?></td>
        <td><?php echo $row[5]?></td>
    </tr>
    <tr>
    <tr>
<?php
}
?>
    <tr class="info">
    <?php
        $sql2 ="SELECT AVG(  `hasil` ) FROM  `tbl_nil_ujian`   AS n LEFT JOIN  `tbl_siswa` AS s ON n.id_siswa = s.id_siswa  WHERE `sesi` ='$sesi' and `nama` = '$nama' and `kelas` ='$kelas'";
        $query2 = mysql_query($sql2);
        $row2 = mysql_fetch_row($query2);
    ?>
        <td colspan="3">
            <center><strong>Jumlah</strong></center>
        </td>
        <td>
            <center><strong>
            <?php
            echo number_format($row2[0],1);
            ?>
            </strong></center>
        </td>
    </tr>
    </tbody>
    </table>
    <br/>
<?php
    }

    }
?>

  </div>