Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <center><h3>Form Input SPP Per Siswa</h3></center>
- <form method="POST" action="./dXBkYXRlX2lucHV0X3NwcF9zaXN3YQ.htm" >
- <table class="table table-hover">
- <?php
- //bulan
- $bulangasal = array("juli","agustus","september","oktober","nopember","desember");
- $bulangenap = array("januari","februari","maret","april","mei","juni");
- //select semester
- $semes = mysql_fetch_array(mysql_query("SELECT kode, ket_smstr
- FROM semester
- WHERE aktif='aktif'"))or die(mysql_error());
- $status = $semes['ket_smstr'];
- //mencaritahu gasal atau genap
- $s = explode(" ", $status);
- $g = $s[0];
- //bulan
- $bulan = ($g == 'Gasal')?$bulangasal:$bulangenap;
- $val=date('m')%6;
- $val=$val==0?6:$val;
- ?>
- <thead>
- <tr>
- <th>NIS</th>
- <th>Nama</th>
- <?php
- //buat bulan
- for($n=0; $n<=5; $n++){
- echo "<th>".ucfirst($bulan[$n])."</th>";
- }
- ?>
- </tr>
- </thead>
- <tbody>
- <?php
- $siswa = mysql_query("SELECT nis, nama
- FROM student
- WHERE nis='".$_POST['nis']."' ");
- while ($s = mysql_fetch_array($siswa)) {
- echo "<tr>
- <td>".$s['nis']."</td>
- <td>".$s['nama']."
- <input type='hidden' name='kode' value='".$semes['kode']."'>
- <input type='hidden' name='nis' value='".$s['nis']."'>
- <input type='hidden' name='statusbulan' value='$g'>
- </td>";
- //query untuk valuenya
- $h = mysql_num_rows(mysql_query("SELECT *
- FROM keu_".$semes['kode']."
- WHERE nis='".$s['nis']."'"));
- if($h == '0'){
- for($n=0; $n<=5; $n++){
- echo "<td>
- <label class='checkbox'>
- <input type='checkbox'
- name=input[".$bulan[$n]."]
- value='".$val."'>
- </label>
- </td>";
- }
- }else{
- $keu = mysql_fetch_array(mysql_query("SELECT *
- FROM keu_".$semes['kode']."
- WHERE nis='".$s['nis']."'"))or die(mysql_error());
- for($n=0; $n<=5; $n++){
- echo "<td>
- <label class='checkbox'>
- <input type='checkbox'
- name=input[".$bulan[$n]."]
- value='".$val."' "
- .($keu[$bulan[$n]] != null?"checked='checked'":"").">
- </label>
- </td>";
- }
- }
- echo "</tr>";
- }
- ?>
- </tbody>
- </table>
- <center><button class="btn"><i class="icon-info-sign"></i> Input SPP</button></center>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment