API tools faq
paste
Advertisement
GWibisono

silakan coba

GWibisono
May 14th, 2014
186
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.25 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $mysqli = new mysqli("localhost", "root", "", "test");
  3.  
  4.  
  5. if(isset($_POST['act']))
  6. {
  7.     $ar=array('name'=>$_POST['name']);
  8.     //===list dosen=====
  9.     $dosen=array();$pos=0;
  10.     $sql="select id,name from dosen order by id ";
  11.     if ($result = $mysqli->query($sql)) {
  12.          while ($row = $result->fetch_assoc()) {
  13.             $dosen[$row['id']]=$row['name'];
  14.             if($pos==0) $dosenAwal=$row['id'];
  15.         }
  16.  
  17.  
  18.     }else{
  19.         die('error '.$sql);
  20.    
  21.     }
  22.     //print_r($dosen);
  23.     //====dapatkan dosen yg terbanyak pegang mahasiswa
  24.     $sql="select d.id,count(d.id) c  from dosen d,mahasiswa m
  25.     where d.id=m.dosen group by d.id
  26.     order by c desc limit 1";
  27.     if ($result = $mysqli->query($sql)) {
  28.          $row = $result->fetch_assoc();
  29.         $terbanyak=$row['c'];
  30.          
  31.     }else{
  32.         die('error '.$sql);
  33.    
  34.     }
  35.     //echo "<br>terbanyak=$terbanyak";
  36.     //====kalau masih kosong
  37.     if($terbanyak==0)
  38.     {
  39.         reset($dosen);
  40.         $bar = each($dosen);
  41.         $ar['dosen']=$bar['key'];
  42.          
  43.     }else{
  44.         $sql="select d.id,count(d.id) c  from dosen d,mahasiswa m
  45.     where d.id=m.dosen
  46.     group by d.id
  47.     order by c desc ";
  48.         if ($result = $mysqli->query($sql)) {
  49.             while ($row = $result->fetch_assoc())
  50.             {
  51.                if($row['c'] == $terbanyak)
  52.                {
  53.                 unset($dosen[$row['id']]);
  54.                 echo "<br>hapus $row[id]";
  55.                }
  56.             }
  57.             //print_r($dosen);
  58.         }else{
  59.             die('error '.$sql);
  60.        
  61.         }
  62.    
  63.         reset($dosen);
  64.         $bar = each($dosen);
  65.         $ar['dosen']=$bar['key'];
  66.            
  67.     }
  68.     //print_r($dosen);
  69.     if(count($dosen)==0){
  70.         $ar['dosen']=$dosenAwal;
  71.         //echo 'tidak ada dosen'.count($dosen);
  72.     }else{
  73.      //echo "ada!";
  74.     }
  75.     //print_r($ar);die();
  76.     $sql="insert into mahasiswa (name,dosen)values('{$ar['name']}',{$ar['dosen']});";
  77.     if ($result = $mysqli->query($sql)) {
  78.    
  79.    
  80.     }else
  81.     {
  82.    
  83.     }
  84.     header('location:?d=load');
  85. //  print_r($dosen);print_r($ar);
  86.     die();
  87. }
  88.  
  89. ?>
  90. <!doctype html>
  91. <html lang="en">
  92. <head>
  93. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  94. <title>Untitled Document</title>
  95.  
  96. <style>
  97. .login{
  98.     width:500px;
  99.     margin:30px auto;
  100. }
  101. </style>
  102. </head>
  103.  
  104. <body>
  105. <!--form-->
  106. <form method="post" class="pure-form" id='login' >
  107. Nama Mahasiswa <input name="name" type=text /> <input type=submit value='update' />
  108. <input type=hidden value='insert' name='act' />
  109. </form>
  110. </body>
  111. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!