Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $kode = $_POST['kode'];
- $nis = $_POST['nis'];
- $input=$_POST['input'];
- $statusbulan=$_POST['statusbulan'];
- $bulangasal = array("juli","agustus","september","oktober","nopember","desember");
- $bulangenap = array("januari","februari","maret","april","mei","juni");
- $bulan = $statusbulan=='Gasal'?$bulangasal:$bulangenap;
- $query = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());
- if (mysql_num_rows($query)=='1') {
- $data=mysql_fetch_array($query);
- foreach($bulan as $bln){
- if($data[$bln]!=$input[$bln]){
- $qry=mysql_query("UPDATE keu_".kode."
- SET $bln=".(isset($input[$bln])?$input[$bln]:'NULL')."
- WHERE nis=".$nis) or die(mysql_error());
- $aktifitas="User operator {$_SESSION['login_name']} "
- ."menginput spp siswa dengan nis={$nis} bulan={$bln}";
- include "keylog.php";
- }
- }
- } else {
- $sql="INSERT keu_".kode." (id_keu, nis, ".implode(',', $bulan).") VALUES ('','$nis'";
- foreach($bulan as $bln){
- $sql.=",".(isset($input[$bln])?$input[$bln]:'NULL');
- }
- $sql.=") WHERE nis=".$nis;
- $aktifitas="User operator {$_SESSION['login_name']} "
- ."menginput spp siswa dengan nis={$nis} bulan=".implode(',', $bulan);
- include "keylog.php";
- $qry=mysql_query($sql) or die(mysql_error());
- header('location: aW5wdXRfcGVyc2lzd2E-'.$setting->safe_b64encode($qry?'2':'1').'.htm');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment