Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form action="?admin=add_viiigenap" method="POST">
- <?php
- $no = 1;
- $sql_laporan = mysqli_query($link, "select tbl_mapel.kd_mapel,tbl_mapel.nama_mapel,tbl_kelas.id_kelas,tbl_kelas.kelas,tbl_kelas.kd_kelas,
- tbl_siswa.nis,tbl_siswa.nama_lengkap,rekap_nilai.semester,rekap_nilai.kkm,
- rekap_nilai.nilai_akhir,rekap_nilai.keterangan from
- tbl_mapel,tbl_siswa,tbl_kelas,rekap_nilai where rekap_nilai.kd_mapel=tbl_mapel.kd_mapel
- and rekap_nilai.id_kelas=tbl_kelas.id_kelas and rekap_nilai.nis=tbl_siswa.nis
- and rekap_nilai.nis='$nis' and rekap_nilai.semester='Genap' and tbl_kelas.kd_kelas='VIII' order by rekap_nilai.kd_mapel
- asc");
- $jml_lap = mysqli_num_rows($sql_laporan);
- if ($jml_lap > 0) {
- ?>
- <table id="example2" class="table table-bordered table-hover">
- <thead>
- <tr class="">
- <th rowspan="3" width="5%">No</th>
- <th rowspan="3" width="10%">Kode Mapel</th>
- <th rowspan="3" width="30%">Mata Pelajaran</th>
- <th rowspan="3" width="5%">KKM*)</th>
- <th colspan="2" >Nilai</th>
- <th rowspan="3" width="20%">Deskripsi Nilai</th>
- </tr>
- <tr class="">
- <th rowspan="2" width="5%" align="center">Angka</th>
- <th rowspan="2" width="20%" align="center">Huruf</th>
- <!-- <th align="center">Registrasi</th> -->
- </tr>
- </thead>
- <tbody>
- <?php
- //
- while ($data_mhs = mysqli_fetch_array($sql_laporan)) {
- //$kelas=$data_mhs['id_kelas'];
- ?>
- <tr>
- <td><?php echo $no; ?></td>
- <td><input class="form-control" type="hidden" id="nis" name="nis[]" value="<?php echo $data_mhs['nis']?>" >
- <?php echo "<input class='form-control' type='text' id='kd_mapel' name='kd_mapel[]' value='".$data_mhs['kd_mapel']."'>"?></td>
- <td><?php echo $data_mhs['nama_mapel']; ?></td>
- <td><?php echo "<input class='form-control' type='text' id='kkm' name='kkm[]' value='".$data_mhs['kkm']."'>"?></td>
- <td><?php echo "<input class='form-control' type='text' id='NA' name='NA[]' value='".$data_mhs['nilai_akhir']."'>"?></td>
- <td><?php echo "<input class='form-control' type='text' id='ket' name='ket[]' value='".$data_mhs['keterangan']."'>"?></td>
- <td>
- <input class="form-control" type="hidden" name="semester[]" id="semester" value="<?php echo $data_mhs['semester']?>">
- <input class="form-control" type="hidden" name="kelas[]" id="kelas" value="<?php echo $data_mhs['id_kelas']?>">
- <input class="form-control" type="text" id="desk" name="desk[]" >
- </td>
- </tr>
- <?php
- $no++;
- }
- ?>
- <?php
- } else {
- ?>
- <div class="alert alert-dismissable alert-info">
- <button type="button" class="close" data-dismiss="alert">×</button>
- <small><strong><i class="fa fa-warning fa-fw fa-2x"></i>Maaf !</strong> Nilai Anda Semester ini belum dimasukkan.</small>
- </div>
- <?php
- }
- ?>
- </tbody>
- </table>
- </div>
- </table>
- </div>
- </div> -->
- <button type="submit" class="btn btn-primary btn-flat" name="tambah_raport"><i class="fa fa-save fa-fw fa-lg"></i> Simpan Data</button>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment