Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $kode = $_POST['kode'];
- $nis = $_POST['nis'];
- $input= $_POST['input'];
- $v = array();
- $bulan = array();
- //mencari tahu apakah dalam tabel keu sudah ada data siswa yg bersangkutan
- $query = mysql_query("SELECT * FROM keu_".$kode." WHERE nis=".$nis)or die(mysql_error());
- //di ambil pas bagian post input aja
- $q=array();
- $ar=array('juli','agustus','september','oktober','nopember','desember');
- $null=implode("=''," $ar)."=''";
- $q[] = "update keu_".$kode." SET $null WHERE nis=".$nis;
- foreach ($input as $month => $val) {
- //buat tmp arraynya
- $tmp_set_on_update[] = $month .'='. $val;
- $bulan[] = $month;
- $v[] = $val;
- //jika ditemukan data maka update
- //mencari apakah sudah terceklist sebelumnya..
- $data = mysql_fetch_array($query);
- if($data[$month] != null)
- {
- //echo $data[$month];
- }else{
- $q[] = "update keu_".$kode." SET ".$month."=".$val." WHERE nis=".$nis;
- $aktifitas="User Operator ".$_SESSION['login_name']." menginput spp siswa dengan nis=".$nis." bulan ".$month;
- include"keylog.php";
- } // if($data[$month] != null)
- }//foreach ($input as $month => $val) {
- foreach($q as $sql){
- $r=mysql_query($sql) or die(mysql_error()."<br>$sql");
- }
- //jika ditemukan data maka update
- if(mysql_num_rows($query) == '0'){
- //jika tidak ditemukan data maka insert
- $q = mysql_query("insert into keu_".$kode." (id_keu, nis, ".implode(',', $bulan).") values ('','$nis','".implode("','",$v)."')")or die(mysql_error().$sql);
- $aktifitas="User Operator ".$_SESSION['login_name']." menginput spp siswa dengan nis=".$nis." bulan ".implode(',', $bulan);
- include"keylog.php";
- if($q)
- {
- header('location: aW5wdXRfcGVyc2lzd2E-'.$setting->safe_b64encode('2').'.htm');
- }
- else
- {
- header('location: aW5wdXRfcGVyc2lzd2E-'.$setting->safe_b64encode('1').'.htm');
- }
- }else{
- echo "data ditemukan ";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement