View difference between Paste ID: ewEPcQef and 8d2RGU1b

-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<!--
 KENAPA KAMU NGAK NULIS QUERY DI FUNGSI YANG PALING BAWAH
 KUKIRA KAMU MENGERTI KOMEN2 YANG KUKASI!!!!
 --><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Untitled Document</title>
 </head>
 
-$C_TIM=$_POST["C_TIM"];
+
-$HARI=$_POST["HARI"];
+
-$TGL=$_POST["TGL"];
+
-$KET=$_POST["KET"];
+        $C_TIM=$_POST["C_TIM"];
-$KTP=$_POST["KTP"];
+        $HARI=$_POST["HARI"];
-$NM=$_POST["NM"];
+        $TGL=$_POST["TGL"];
-$TMPT_LHIR=$_POST["TMPT_LHIR"];
+        $KET=$_POST["KET"];
-$TGL_LHIR=$_POST["TGL_LHIR"];
+        $KTP=$_POST["KTP"];
-$PKERJAAN=$_POST["PKERJAAN"];
+        $NM=$_POST["NM"];
-$ALAMAT=$_POST["ALAMAT"];
+        $TMPT_LHIR=$_POST["TMPT_LHIR"];
-$NO_HP=$_POST["NO_HP"];
+        $TGL_LHIR=$_POST["TGL_LHIR"];
-$TLP=$_POST["TLP"];
+        $PKERJAAN=$_POST["PKERJAAN"];
-$ID_PEL=$_POST["ID_PEL"];
+        $ALAMAT=$_POST["ALAMAT"];
-$NO_METER=$_POST["NO_METER"];
+        $NO_HP=$_POST["NO_HP"];
-$TRIF_LM=$_POST["TRIF_LM"];
+        $TLP=$_POST["TLP"];
-$DY_LM=$_POST["DY_LM"];
+        $ID_PEL=$_POST["ID_PEL"];
-$TRIF_BR=$_POST["TRIF_BR"];
+        $NO_METER=$_POST["NO_METER"];
-$DY_BR=$_POST["DY_BR"];
+        $TRIF_LM=$_POST["TRIF_LM"];
-$TGNGN_NORMAL=$_POST["TGNGN_NORMAL"];
+        $DY_LM=$_POST["DY_LM"];
-$GARDU=$_POST["GARDU"];
+        $TRIF_BR=$_POST["TRIF_BR"];
-$TIANG=$_POST["TIANG"];
+        $DY_BR=$_POST["DY_BR"];
-$NO_TOKEN=$_POST["NO_TOKEN"];
+        $TGNGN_NORMAL=$_POST["TGNGN_NORMAL"];
-$NO_KSR=$_POST["NO_KSR"];
+        $GARDU=$_POST["GARDU"];
-$NO_MAT=$_POST["NO_MAT"];
+        $TIANG=$_POST["TIANG"];
         $NO_TOKEN=$_POST["NO_TOKEN"];
         $NO_KSR=$_POST["NO_KSR"];
-$randmin = "1111111111";
+        $NO_MAT=$_POST["NO_MAT"];
-$randmin1 = "1234567891";
+
-$randmax = "9999999999";
+
-$rand1 = rand($randmin,$randmax);
+        $randmin = "1111111111";
-$rand2 = rand($randmin1,$randmax);
+        $randmin1 = "1234567891";
-$rand3 = rand($randmin,$randmin1);
+        $randmax = "9999999999";
-$rand4 = rand($randmax,$randmin1);
+        $rand1 = rand($randmin,$randmax);
-$rand5 = rand($randmax,$randmin);
+        $rand2 = rand($randmin1,$randmax);
-$KCT  = $rand1.$rand2;
+        $rand3 = rand($randmin,$randmin1);
-$KCT2 = $rand1.$rand3;
+        $rand4 = rand($randmax,$randmin1);
-$CC   = $rand1.$rand4;
+        $rand5 = rand($randmax,$randmin);
-$FIT  = $rand2.$rand3;
+        $KCT  = $rand1.$rand2;
-$PW   = $rand2.$rand4;
+        $KCT2 = $rand1.$rand3;
-$CT   = $rand3.$rand4;
+        $CC   = $rand1.$rand4;
-$CT2  = $rand4.$rand5;
+        $FIT  = $rand2.$rand3;
         $PW   = $rand2.$rand4;
         $CT   = $rand3.$rand4;
-//query simpan yg panjang
+        $CT2  = $rand4.$rand5;
- $aplg="INSERT INTO tm_plg VALUES ('$KTP','$NO_MAT','$C_TIM','$ID_PEL','$NO_METER','$NO_KSR','$NM','$TMPT_LHIR','$TGL_LHIR','$PKERJAAN','$ALAMAT','$NO_HP','$TLP','$KET',1,1)";
+
-$bplg="INSERT INTO td_plg VALUES ('$ID_PEL','$NO_METER','$NO_TOKEN','$KTP','$HARI','$TGL','$TRIF_LM','$DY_LM','$TRIF_BR','$DY_BR','$TGNGN_NORMAL','$GARDU','$TIANG')";
+
-$tkn="INSERT INTO t_token VALUES ('$NO_TOKEN','$C_TIM','$ID_PEL','$NO_METER','$KCT','$KCT2','$CT','$CT2','$CC','$FIT','$PW')";
+
-$ksr="INSERT INTO t_kasir VALUES ('$NO_KSR','$C_TIM','$KTP',0)";
+
-$mtr="INSERT INTO t_material VALUES ('$NO_MAT','$C_TIM','$KTP',0,0,0,0,0)";
+$stat=0;
   $sql="select a.KTP from tm_plg a, td_plg b where a.KTP='$KTP' and NM='$NM' and a.KTP=b.KTP and b.ID_PEL=a.ID_PEL and b.NO_METER=a.NO_METER";
 if(!adaIsinya($sql)){
-echo $sql="select a.KTP from tm_plg a, td_plg b where a.KTP='$KTP' and NM='$NM' and a.KTP=b.KTP and b.ID_PEL=a.ID_PEL and b.NO_METER=a.NO_METER";
+
 }
 echo "<br>$sql<br>stat=$stat";
 
   $sql="select a.ID_PEL, a.NO_METER from td_plg a, tm_plg b where a.ID_PEL='$ID_PEL' and a.NO_METER='$NO_METER' and b.KTP=a.KTP";
-echo $sql1="select a.ID_PEL, a.NO_METER from td_plg a, tm_plg b where a.ID_PEL='$ID_PEL' and a.NO_METER='$NO_METER' and b.KTP=a.KTP";
+
-if(!adaIsinya($sql1)){
+
 }
 echo "<br>$sql<br>stat=$stat";
 
-echo $sql2="select a.NO_TOKEN from t_token a, td_plg b where a.NO_TOKEN='$NO_TOKEN' and a.NO_TOKEN=b.NO_TOKEN and b.ID_PEL=a.ID_PEL and a.NO_METER=b.NO_METER";
+  $sql="select a.NO_TOKEN from t_token a, td_plg b where a.NO_TOKEN='$NO_TOKEN' and a.NO_TOKEN=b.NO_TOKEN and b.ID_PEL=a.ID_PEL and a.NO_METER=b.NO_METER";
-if(!adaIsinya($sql2)){
+
         $stat++;
 }
 echo "<br>$sql<br>stat=$stat";
-echo $sql3="select a.NO_KSR from t_kasir a, td_plg b, tm_plg c where a.NO_KSR='$NO_KSR' and a.NO_KSR=c.NO_KSR and b.ID_PEL=c.ID_PEL and b.NO_METER=c.NO_METER and c.KTP=a.KTP";
+
-if(!adaIsinya($sql3)){
+$sql ="select a.NO_KSR from t_kasir a, td_plg b, tm_plg c where a.NO_KSR='$NO_KSR' and a.NO_KSR=c.NO_KSR and b.ID_PEL=c.ID_PEL and b.NO_METER=c.NO_METER and c.KTP=a.KTP";
 if(!adaIsinya($sql)){
         $stat++;
 }
-echo $sql4="select a.NO_MAT from t_material a, td_plg b, tm_plg c where a.NO_MAT='$NO_MAT' and a.NO_MAT=c.NO_MAT and b.ID_PEL=c.ID_PEL
+echo "<br>$sql<br>stat=$stat";
 
-if(!adaIsinya($sql4)){
+  $sql="select a.NO_MAT from t_material a, td_plg b, tm_plg c where a.NO_MAT='$NO_MAT' and a.NO_MAT=c.NO_MAT and b.ID_PEL=c.ID_PEL
 and b.NO_METER=c.NO_METER and c.KTP=a.KTP";
 if(!adaIsinya($sql)){
         $stat++;
 }
 echo "<br>$sql<br>stat=$stat";
-$hsla=@mysql_query($aplg,$idkoneksi);
+
-$hslb=@mysql_query($bplg,$idkoneksi);
+
-$tkn=@mysql_query($tkn,$idkoneksi);
+
-$ksr=@mysql_query($ksr,$idkoneksi);
+        //query simpan yg panjang
-$mtr=@mysql_query($mtr,$idkoneksi);
+         $aplg="INSERT INTO tm_plg VALUES ('$KTP','$NO_MAT','$C_TIM','$ID_PEL','$NO_METER','$NO_KSR','$NM','$TMPT_LHIR','$TGL_LHIR','$PKERJAAN','$ALAMAT','$NO_HP','$TLP','$KET',1,1)";
         $bplg="INSERT INTO td_plg VALUES ('$ID_PEL','$NO_METER','$NO_TOKEN','$KTP','$HARI','$TGL','$TRIF_LM','$DY_LM','$TRIF_BR','$DY_BR','$TGNGN_NORMAL','$GARDU','$TIANG')";
         $tkn="INSERT INTO t_token VALUES ('$NO_TOKEN','$C_TIM','$ID_PEL','$NO_METER','$KCT','$KCT2','$CT','$CT2','$CC','$FIT','$PW')";
         $ksr="INSERT INTO t_kasir VALUES ('$NO_KSR','$C_TIM','$KTP',0)";
         $mtr="INSERT INTO t_material VALUES ('$NO_MAT','$C_TIM','$KTP',0,0,0,0,0)";
 
         $hsla=@mysql_query($aplg,$idkoneksi);
         $hslb=@mysql_query($bplg,$idkoneksi);
         $tkn=@mysql_query($tkn,$idkoneksi);
-function adaIsinya($sql&$sql1&$sql2&$sql3&$sql4)
+        $ksr=@mysql_query($ksr,$idkoneksi);
         $mtr=@mysql_query($mtr,$idkoneksi);
-//lakukan query
+
-//cari jumlahnya
+
-        if($tot==0){
+
-           echo     return FALSE;
+
-        }else{
+die('done');
-               echo return $tot;
+
 @mysql_close($idkoneksi);
 
 function adaIsinya($sql)
 {
  $r=@mysql_query($sql);
  $tot=@mysql_num_rows($r);
          if($tot>0){
             return $tot;
         }
 
 }
 ?>
 </body>
 </html>