Advertisement
GWibisono

LOGIKANYA RUMIT LHO..SIAPKAN KOPI

Jan 5th, 2014
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2.     $id_kelas=$_POST['kelas']; 
  3.     $id_ajaran=$_POST['ajaran'];
  4.     $no=0;
  5.     $a=0;
  6.     $b=0;
  7.     $c=0;
  8.     $v=0;
  9.     $y=0;
  10.     $z=0;
  11.     $f=0;
  12.     $g=0;
  13.     $h=0;
  14.     $p=0;
  15.     $e=0;
  16. ?>
  17. <?php
  18. $sql =" select * from tb_detailkelas
  19.             where id_kelas='$id_kelas' and id_ajaran='$id_ajaran'";
  20.             $hasil = mysql_query($sql) ;//or die ("Kesalahan pada perintah SQL!");
  21.             echo mysql_error();
  22.             while ($data=mysql_fetch_array($hasil)){
  23.         ?>
  24.             <tr>
  25.                 <td><?php   $no; ?> </td>
  26.                 <td><?php   $data['nis']?></td>
  27.                
  28.             </tr>
  29. <?php
  30. $test=$data['nis'];
  31. $ARSISWA=array();
  32. $no++;
  33. $sql1 =" select * from tb_rapot
  34. where nis='$test' and id_ajaran='$id_ajaran' order by nilai_rapot desc";
  35.     $hasil1 = mysql_query($sql1) ;
  36.  
  37.     echo mysql_error();
  38.     while ($data1=mysql_fetch_array($hasil1)){
  39.     ?>
  40.     <tr>
  41.         <td><?php   $no; ?> </td>
  42.         <td><?php   $data1['nis']?></td>
  43.         <td><?php   $data1['nilai_rapot']?></td>
  44.        
  45.     </tr>
  46.     <?php
  47.        $ARSISWA[$data1['nis']]= $data1['nilai_rapot'];
  48.        
  49.     }
  50.                        
  51.  
  52. ?></table>
  53.  
  54. <table>
  55. <?php
  56.  arsort($ARSISWA);
  57. $i=0;
  58. foreach($ARSISWA as $nm=>$val)
  59. {
  60. $i++;
  61. ?><tr><td><?=$i;?></td><td><?=$nm;?></td>
  62. <td><?=$val;;?></td></tr><?php
  63.     if($i>=3) break;
  64. }
  65. ?>
  66. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement