absensi siswa

//=== FORM INPUTAN
<?php
  include "conn.php";
  $query=mysql_fetch_array(mysql_query("SELECT nama_kelas FROM kelas WHERE kd_kelas='{$_GET['kd_kelas']}'"));
?>
<div class="post">
  <h2 class="title"><a href="#">ABSENSI KELAS <?php echo $query['nama_kelas'];?></a></h2>
  <p class="meta"><em>monday, February 10, 2015 07.00 AM Posted by <a href="#">SMK Wijaya Plus</a></em></p>
  <div class="entry">
    <p>
    <form action="?page=proses" method="post" name="postform">
    <input type="hidden" value="<?php echo $_GET['kd_kelas'];?>" name="kd_kelas"/>
    <table class="datatable">
    <tr>
      <td width="24%" align="left" colspan="6">Tanggal :
      <input type="text" name="tanggal"  value="<?php echo (!isset($_POST['tgl'])?date('d/m/Y'):$_POST[tgl]);?>" size="11">
        <a href="javascript:void(0)" onClick="if(self.gfPop)gfPop.fPopCalendar(document.postform.tanggal);return false;" >
        <img name="popcal" align="absmiddle" src="calender/calbtn.gif" width="34" height="29" border="0" alt=""></a>
      </td>
    </tr>
    <tr>
      <th>No</th>
      <th>Nama</th>
      <th>Hadir (H)</th>
      <th>Sakit (S)</th>
      <th>Ijin (I)</th>
      <th>Alfa (A)</th>
    </tr>
    <?php
    $no=0;
    $query=mysql_query("SELECT nama,kd_siswa FROM siswa WHERE kd_kelas='{$_GET['kd_kelas']}'");
    $keterangan=array('h','s','i','a');
    while($row=mysql_fetch_array($query)){
    ?>
    <tr>
      <td><?php echo $no++;?></td><td><?php echo $row['nama'];?></td>
      <?php foreach($keterangan as $k){?>
      <td align="center">
        <input type="radio" name='keterangan[<?php echo $row['kd_siswa'];?>]' value='<?php echo $k;?>' /></td>
      </td>
    <?php }?>
    </tr>
    <?php
    }
    ?>
    </table>
    <br />
    <input type="checkbox" name="selesai" value="yes" />Tandai Kelas Selesai
    <br /><br />
    <input type="submit" value="Submit" />
    </form>
    </p>
  </div>
</div>

<iframe width=174 height=189 name="gToday:normal:calender/agenda.js" id="gToday:normal:calender/agenda.js" src="calender/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; top:-500px; left:-500px;">
</iframe>


//==== FILE PROSES
<?php
if(isset($_POST['selesai'])){
  include "conn.php";
  $sql="INSERT INTO absensi(kd_siswa,kd_kelas,keterangan,tanggal,selesai) VALUES"
  $data=array();
  foreach($_POST['status'] as $kd_siswa=>$keterangan)
    $data[]="('{$kd_siswa}','{$_POST['kd_kelas']}','{$keterangan}','$_POST['tanggal]}','yes')"
  $result=mysql_query($sql.implode(',',$data),$koneksi);
  ?>
  <script language="javascript">
  document.location.href="?page=view_absensi&kd_kelas=<?php echo $_POST['kd_kelas'];?>&tanggal=<?php echo $_POST['tanggal'];?>";
  </script>
  <?php
}
?>

///==== VIEW
<?php include "conn.php";
$kd_kelas=$_GET['kd_kelas'];
$tanggal=$_GET['tanggal'];
$sql="SELECT nama_kelas FROM kelas WHERE kd_kelas='$kd_kelas'";
$result=mysql_query($sql);
$data=mysql_fetch_assoc($result);
?>
<div class="post">
  <h2 class="title"><a href="#">VIEW ABSENSI KELAS <?php echo $data['nama_kelas'];?></a></h2>
  <p class="meta"><em>monday, February 10, 2015 07.00 AM Posted by <a href="#">SMK Wijaya Plus</a></em></p>
  <div class="entry">
    <p>
    <table class="datatable">
    <tr>
      <th>No</th>
      <th>Nama</th>
      <th>Hadir (H)</th>
      <th>Sakit (S)</th>
      <th>Ijin (I)</th>
      <th>Alfa (A)</th>
    </tr>
    <?php
    $sql="
    SELECT b.nama,
    IF(a.keterangan='h',1,0) AS hadir,
    IF(a.keterangan='s',1,0) AS sakit,
    IF(a.keterangan='i',1,0) AS ijin,
    IF(a.keterangan='a',1,0) AS alfa
    FROM absensi a
    JOIN siswa USING(kd_siswa)
    WHERE
    a.kd_kelas='$kd_kelas'
    AND
    a.tanggal='$tanggal'";
    $result=mysql_query($sql,$koneksi);
    $no=0;
    while($row=mysql_fetch_assoc($result)){
      ?>
      <tr>
        <td><?php echo ++$no;?></td>
        <td><?php echo $row['nama'];?></td>
        <td align="center"><?php echo $row['hadir'];?></td>
        <td align="center"><?php echo $row['sakit'];?></td>
        <td align="center"><?php echo $row['ijin'];?></td>
        <td align="center"><?php echo $row['alfa'];?></td>
      </tr>
      <?php
    }
    ?>
    </table>
  </div>
</div>
<iframe
  width=174
  height=189
  name="gToday:normal:calender/agenda.js"
  id="gToday:normal:calender/agenda.js"
  src="calender/ipopeng.htm"
  scrolling="no"
  frameborder="0"
  style="visibility:visible; z-index:999; position:absolute; top:-500px; left:-500px;">
</iframe>