View difference between Paste ID: 2zta9TB1 and eEGR7kwh

 <?php if ( ! defined('CMS')) exit('Akses Ditolak Silahkan Gunakan Aplikasi dengan Bijak...');
 
 // buat tanggal sekarang
 $tanggal = date('Y-m-d');
 $tanggal_arr = explode(' ', $tanggal);
 $txt_tanggal = tgl_indo($tanggal_arr[0]);
 ?>
 
 
 <!-- tampilkan form -->
 <?php if(empty($ok)) { ?>
 
 <form method="POST" action="">
 <div class="box box-primary">
 	<div class="box-header">
 			<h3 class="box-title"><b/>REKAP DATA ABSENSI</h3>
 	</div>
 	<div class="box-body" >
 	<div class="form-group">
       <label class="control-label" >Dari : </label>
       <div class="input-group date dtpicker col-md-5" style="z-index: 9999 !important;">
         <div class="input-group-addon"><i class="fa fa-calendar"></i></div>
         <input type="text" name="tgl_lahir_txt" id="tgl_lahir_txt" value="<?php echo $txt_tanggal ?>" required="true" readonly="readonly" class="form-control" style="width:50%" /><br>
         <input type="hidden" name="tgl1" id="tgl1" value="<?php echo $tanggal ?>"  />
       </div>
     </div>
 	<div class="form-group">
       <label class="control-label" >Sampai Dengan : </label>
       <div class="input-group date dtpicker col-md-5" style="z-index: 9999 !important;">
         <div class="input-group-addon"><i class="fa fa-calendar"></i></div>
         <input type="text" name="tgl_lahir_txt" id="tgl_lahir_txt" value="<?php echo $txt_tanggal ?>" required="true" readonly="readonly" class="form-control" style="width:50%" /><br>
         <input type="hidden" name="tgl2" id="tgl2" value="<?php echo $tanggal ?>"  />
       </div>
     </div>
 		<div class="box-footer">
 			<input class="btn btn-success" type="submit" name="rekap" value="Rekap" >
 			<input type="button"  class="btn btn-warning " value="Batal" onclick="history.go(-1)">
 		</div>
 	</div>
 </div>
 </form>
 
 <div class="box">
   <div class="box-header">
     <h3 class="box-title">REKAP DATA ABSENSI</h3>
   </div><!-- /.box-header -->
   <div class="box-body">
     <table id="example1" class="table table-bordered table-striped">
       <thead>
         <tr>
           <th class="header_kolom" style="width:5%"> No.</th>
           <th class="header_kolom" style="width:45%"> ID/NISN</th>
           <th class="header_kolom" style="width:10%"> Hadir</th>
           <th class="header_kolom" style="width:10%"> Alpha</th>
           <th class="header_kolom" style="width:10%"> Sakit</th>
           <th class="header_kolom" style="width:10%"> Izin</th>
           <th class="header_kolom" style="width:10%"> Bolos</th>
         </tr>
       </thead>
       <tbody>
         <?php
 		//SIMPAN DATA
 if ($_POST) {
 	$error = array(); // variabel jika error
 	$ok = array(); // variabel jika berhasil
 
 	//variabel kiriman POST
 	$tgl1				=$_POST['tgl1'];
 	$tgl2				=$_POST['tgl2'];
 
 	// validasi data kosong
 	if (empty($tgl1) || empty($tgl2)) {
 	$error[] = 'Tanggal Harus Diisi!';
 	}
 
 	if(empty($error)) { // gak ada error
 
 		// SQLi Query rekap hadir
 		$hadir = "SELECT*FROM tbl_absensi WHERE keterangan='Masuk' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
 		$rkp_hadir = mysqli_query($konek, $hadir);
 		$jml_hadir = mysqli_num_rows($rkp_hadir);
 
 		// SQLi Query rekap alpha
 		$alpha = "SELECT*FROM tbl_absensi WHERE keterangan='Alpha' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
 		$rkp_alpha = mysqli_query($konek, $alpha);
 		$jml_alpha = mysqli_num_rows($rkp_alpha);
 
 		// SQLi Query rekap sakit
 		$sakit = "SELECT*FROM tbl_absensi WHERE keterangan='Sakit' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
 		$rkp_sakit = mysqli_query($konek, $sakit);
 		$jml_sakit = mysqli_num_rows($rkp_sakit);
 
 		// SQLi Query rekap izin
 		$izin = "SELECT*FROM tbl_absensi WHERE keterangan='Izin' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
 		$rkp_izin = mysqli_query($konek, $izin);
 		$jml_izin = mysqli_num_rows($rkp_izin);
 
 		// SQLi Query rekap bolos
 		$bolos = "SELECT*FROM tbl_absensi WHERE keterangan='Bolos' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
 		$rkp_bolos = mysqli_query($konek, $bolos);
 		$jml_bolos = mysqli_num_rows($rkp_bolos);
 
 		//validasi hasil rekap
 		if ($jml_hadir || $jml_alpha || $jml_sakit || $jml_izin || $jml_bolos) {
 			$ok[] = 'Berhasil, Data Sudah Disimpan !';
 		}
 
 
 	// tampilkan jika pesan error
 	if(!empty($error)) {
 		echo '<div class="alert alert-danger alert-dismissable">
 		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
 		<ul>';
 	foreach ($error as $val) {
 		echo '<li>'.$val.'</li>';
 	}
 		echo '</ul></div>';
 	}
 	} // akhir post
 
         $tampil = "SELECT * FROM tbl_absensi ORDER BY id_siswa ASC";
         $hasil = mysqli_query($konek, $tampil);
         $no = 1;
         while ($data = mysqli_fetch_array($hasil)) {
 /*
 lakukan query pencarian berapa kali hadir dll..
 manfaatkan count
-          <td class='h_tengah'> $data[id_siswa]</td>
+$sakit = "SELECT count(*) hitung
 FROM tbl_absensi
 WHERE
 keterangan='Sakit'
 AND (tgl_absensi BETWEEN '$tgl1' AND '$tgl2')
 and id_siswa= $data['id_siswa']";
 */
         echo "
         <tr>
           <td class='h_tengah'> $no</td>
           <td class='h_tengah'> $data[nama_siswa] <!--kyknya harusnya nama bukan id--></td>
           <td class='h_tengah'> $jml_hadir</td>
           <td class='h_tengah'> $jml_alpha</td>
           <td class='h_tengah'> $jml_sakit</td>
           <td class='h_tengah'> $jml_izin </td>
           <td class='h_tengah'> $jml_bolos</td>
           </tr>";
           $no++;
         }
 	}
         ?>
       </tbody>
     </table>
   </div>
 </div>
 
 <!-- page script -->
 <script type="text/javascript">
 $(document).ready(function() {
 	$('#tgl1').focus();
 });
 </script>
 
 <!-- Tanggal Picker -->
 <link href="../template/bootstrap_date_time/css/bootstrap-datetimepicker.min.css" rel="stylesheet" type="text/css" />
 <script src="../template/bootstrap_date_time/js/bootstrap-datetimepicker.min.js" type="text/javascript"></script>
 <script src="../template/bootstrap_date_time/js/locales/bootstrap-datetimepicker.id.js" type="text/javascript"></script>
 
 <script type="text/javascript">
 $(document).ready(function() {
 $(".dtpicker").datetimepicker({
     language:  'id',
     weekStart: 1,
     autoclose: true,
     todayBtn: true,
     todayHighlight: true,
-<?php } // if ok empty ?>
+
     format: "dd MM yyyy",
     linkField: "tgl_lahir",
     linkFormat: "yyyy-mm-dd",
     startView: 2,
 	 minView: 2
   });
 }); // ready
 </script>
 
 <?php
 } // if ok empty ?>