cahyadsn

update v1

Apr 4th, 2014
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.48 KB | None | 0 0
  1. <?php
  2.   $kode = $_POST['kode'];
  3.   $nis  = $_POST['nis'];
  4.   $input=$_POST['input'];
  5.   $statusbulan=$_POST['statusbulan'];
  6.   $bulangasal = array("juli","agustus","september","oktober","nopember","desember");
  7.   $bulangenap = array("januari","februari","maret","april","mei","juni");
  8.   $bulan = $statusbulan=='Gasal'?$bulangasal:$bulangenap;  
  9.   $query = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());
  10.   if (mysql_num_rows($query)=='1') {
  11.     $data=mysql_fetch_array($query);
  12.     foreach($bulan as $bln){
  13.       if($data[$bln]!=$input[$bln]){
  14.         $qry=mysql_query("UPDATE keu_".kode."
  15.                          SET $bln=".(isset($input[$bln])?$input[$bln]:'NULL')."
  16.                          WHERE nis=".$nis) or die(mysql_error());
  17.         $aktifitas="User operator {$_SESSION['login_name']} "
  18.                   ."menginput spp siswa dengan nis={$nis} bulan={$bln}";
  19.         include "keylog.php";
  20.       }
  21.     }
  22.   } else {
  23.     $sql="INSERT keu_".kode." (id_keu, nis, ".implode(',', $bulan).") VALUES ('','$nis'";
  24.     foreach($bulan as $bln){
  25.       $sql.=",".(isset($input[$bln])?$input[$bln]:'NULL');
  26.     }
  27.     $sql.=") WHERE nis=".$nis;
  28.     $aktifitas="User operator {$_SESSION['login_name']} "
  29.               ."menginput spp siswa dengan nis={$nis} bulan=".implode(',', $bulan);
  30.     include "keylog.php";
  31.     $qry=mysql_query($sql) or die(mysql_error());
  32.     header('location: aW5wdXRfcGVyc2lzd2E-'.$setting->safe_b64encode($qry?'2':'1').'.htm');
  33.   }
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment