Untitled

<form name="form1" method="get" action="">
    <div align="center">
      <table width="988">
        <tr>
         <td width="67">Semester</td><td width="82"><input name="semester" type="text" id="semester" size="6" maxlength="6"/></td>
         <td width="44">TA</td><td width="61"><input name="thn_ajaran" type="text" id="thn_ajaran" size="10" maxlength="10"/></td>
         <td width="116">Dari Tanggal</td>
         <td width="521"><select name="tgl1" id="tgl1">
<option>	01	</option>
<option>	02	</option>
<option>	03	</option>
<option>	04	</option>
<option>	05	</option>
<option>	06	</option>
<option>	07	</option>
<option>	08	</option>
<option>	09	</option>
<option>	10	</option>
<option>	11	</option>
<option>	12	</option>
<option>	13	</option>
<option>	14	</option>
<option>	15	</option>
<option>	16	</option>
<option>	17	</option>
<option>	18	</option>
<option>	19	</option>
<option>	20	</option>
<option>	21	</option>
<option>	22	</option>
<option>	23	</option>
<option>	24	</option>
<option>	25	</option>
<option>	26	</option>
<option>	27	</option>
<option>	28	</option>
<option>	29	</option>
<option>	30	</option>
<option>	31	</option>
</select>
<select name="bln1" id="bln1">
<option	 value="01"	>	Januari	</option>
<option	 value="02"	>	Februari	</option>
<option	 value="03"	>	Maret	</option>
<option	 value="04"	>	April	</option>
<option	 value="05"	>	Mei	</option>
<option	 value="06"	>	Juni	</option>
<option	 value="07"	>	Juli	</option>
<option	 value="08"	>	Agustus	</option>
<option	 value="09"	>	September	</option>
<option	 value="10"	>	Oktober	</option>
<option	 value="11"	>	Nopember	</option>
<option	 value="12"	>	Desember	</option>

</select>

<select name="thn1" id="thn1">
<?php for($i=2010;$i<=date("Y");$i++){ ?>
<option><?php echo $i;?></option>
<?php } ?>
</select>
S.d
<select name="tgl2" id="tgl2">
<option> 01 </option>
<option> 02 </option>
<option> 03 </option>
<option> 04 </option>
<option> 05 </option>
<option> 06 </option>
<option> 07 </option>
<option> 08 </option>
<option> 09 </option>
<option> 10 </option>
<option> 11 </option>
<option> 12 </option>
<option> 13 </option>
<option> 14 </option>
<option> 15 </option>
<option> 16 </option>
<option> 17 </option>
<option> 18 </option>
<option> 19 </option>
<option> 20 </option>
<option> 21 </option>
<option> 22 </option>
<option> 23 </option>
<option> 24 </option>
<option> 25 </option>
<option> 26 </option>
<option> 27 </option>
<option> 28 </option>
<option> 29 </option>
<option> 30 </option>
<option> 31 </option>
</select>
<select name="bln2" id="select2">
<option	 value="01"	> Januari </option>
<option	 value="02"	> Februari </option>
<option	 value="03"	> Maret </option>
<option	 value="04"	> April </option>
<option	 value="05"	> Mei </option>
<option	 value="06"	> Juni </option>
<option	 value="07"	> Juli </option>
<option	 value="08"	> Agustus </option>
<option	 value="09"	> September </option>
<option	 value="10"	> Oktober </option>
<option	 value="11"	> Nopember </option>
<option	 value="12"	> Desember </option>
</select>
<select name="thn2" id="select3">>
<?php for($i=2010;$i<=date("Y");$i++){ ?>
<option><?php echo $i;?></option>
<?php } ?>
</select>
         </td>
         <td width="65"><input type="submit" value="Search" name="search" /></td>
      </tr>
        </table>
    </div>
</form>
<html>
	<head>
<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="js/highcharts.js" type="text/javascript"></script>
<script type="text/javascript">
	var chart1; // globally available
$(document).ready(function() {
      chart1 = new Highcharts.Chart({
         chart: {
            renderTo: 'container',
            type: 'column'
         },
         title: {
            text: 'Grafik Presensi Siswa Kelas <?php echo $_GET['kode']; ?> Semester <?php echo $_GET['semester']; ?> Tahun Ajaran <?php echo $_GET['thn_ajaran']; ?> '
         },
         xAxis: {
            categories: ['Sakit','Izin','Alpha']
         },
         yAxis: {
            title: {
               text: 'TOTAL'
            }
         },
              series:
            [
            <?php
        	include('config.php');
			if(isset($_GET['search'])){
			$sm = $_GET['semester'];
			$ta = $_GET['thn_ajaran'];

           $sql   = "SELECT a.nama_kelas,b.tgl_absen,b.semester,b.thn_ajaran,sum(b.ket='Sakit') as Sakit,sum(b.ket='Alpha') as Alpha,sum(b.ket='Izin') as Izin from absensi b,tb_kelas a where b.kd_kelas=a.kd_kelas group by a.nama_kelas";
            $query = mysql_query( $sql )  or die(mysql_error());
            while( $ret = mysql_fetch_array( $query ) ){
            	$merek=$ret['nama_kelas'];
                 $sql_jumlah   = "SELECT a.nama_kelas,b.tgl_absen,b.semester,b.thn_ajaran,sum(b.ket='Sakit') as Sakit,sum(b.ket='Alpha') as Alpha,sum(b.ket='Izin') as Izin from absensi b,tb_kelas a where b.kd_kelas=a.kd_kelas and a.nama_kelas='$merek' and b.semester like '%$sm' and b.thn_ajaran like '%$ta' and a.kode like '%$kd' and b.tgl_absen >= '$thn1-$bln1-$tgl1' AND b.tgl_absen <= '$thn2-$bln2-$tgl2' group by a.nama_kelas";
                 $query_jumlah = mysql_query( $sql_jumlah ) or die(mysql_error());
                 while( $data = mysql_fetch_array( $query_jumlah ) ){
                    $S = $data['Sakit'];
		    $A = $data['Alpha'];
		    $I = $data['Izin'];

                  }
                  ?>
                  {
                      name: '<?php echo $merek; ?>',
                      data: [<?php echo $S; ?>,<?php echo $I; ?>,<?php echo $A; ?>]

                  },

                  <?php }
				  }?>
            ]
      });
   });
</script>
	</head>
	<body>
		<div id='container'></div>
	</body>
</html>