View difference between Paste ID: D2peZUS6 and 1i7TPiY2

 <?php
 if($domain!=='admin' && $domain!=='superadmin'){
 	?><script language="javascript">document.location.href="logout.php"</script><?php
 }
 ?>
 <?php
 if($_GET['mode']=='input'){
 
 	$id_siswa=htmlentities($_POST['id_siswa']);
 	$id_kelas=htmlentities($_POST['id_kelas']);
 
 	$cek_query=mysql_query("select * from tbl_ruangan where id_siswa='$id_siswa' and id_kelas='$id_kelas'");
 	$cek_query2=mysql_query("select * from tbl_ruangan where id_siswa='$id_siswa'");
 	$cek_num=mysql_num_rows($cek_query);
 	$cek_num2=mysql_num_rows($cek_query2);
 
 	if($cek_num!==0 || $cek_num2!==0){
 		?><script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=4";</script><?php
 	}else{
 		$query=mysql_query("insert into tbl_ruangan values('','$id_siswa','$id_kelas')");
 
 		if($query){
 			?><script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=1";</script><?php
 		}
 	}
 }
 
 if($_GET['mode']=='delete'){
 
 	$id_ruangan=$_GET['id_ruangan'];
 	$query=mysql_query("delete from tbl_ruangan where id_ruangan='$id_ruangan'");
 	if($query){
 		?><script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=2";</script><?php
 	}
 }
 
 if($_GET['mode']=='update'){
 	$id_ruangan=$_POST['id_ruangan'];
 
 	$id_siswa=$_POST['id_siswa'];
 	$id_kelas=$_POST['id_kelas'];
 
 	$cek_query=mysql_query("select * from tbl_ruangan where id_siswa='$id_siswa' and id_kelas='$id_kelas'");
 	$cek_num=mysql_num_rows($cek_query);
 
 	if($cek_num!==0){
 		?><script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=0";</script><?php
 	}else{
 
 		$query=mysql_query("update tbl_ruangan set id_siswa='$id_siswa', id_kelas='$id_kelas' where id_ruangan='$id_ruangan'");
 
 		if($query){
 			?><script language="javascript">document.location.href="?page=jadwal_ruangkelas&status=3";</script><?php
 		}else{
 			echo mysql_error();
 		}
 	}
 }
 
 if($_GET['mode']=='edit'){
 	$id_ruangan=$_GET['id_ruangan'];
 	$edit=mysql_query("select * from tbl_ruangan where id_ruangan='$id_ruangan'");
 
 	$data=mysql_fetch_array($edit);
 	$id_siswa=$data['id_siswa'];
 	$id_kelas=$data['id_kelas'];
 }
 ?>
 
 <!--  start page-heading -->
 <div id="page-heading">
     <h1>Ruang Kelas</h1>
 </div>
 <!-- end page-heading -->
 
 <table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table">
 <tr>
     <th rowspan="3" class="sized"><img src="images/shared/side_shadowleft.jpg" width="20" height="300" alt="" /></th>
     <th class="topleft"></th>
     <td id="tbl-border-top">&nbsp;</td>
     <th class="topright"></th>
     <th rowspan="3" class="sized"><img src="images/shared/side_shadowright.jpg" width="20" height="300" alt="" /></th>
 </tr>
 <tr>
     <td id="tbl-border-left"></td>
     <td>
     <!--  start content-table-inner ...................................................................... START -->
     <div id="content-table-inner">
 
             <?php
 			include "warning.php";
 			?>
 
     		<?php
 			if($_GET['mode']=='edit'){
 				?><form action="?page=jadwal_ruangkelas&mode=update" method="post"><?php
 			}else{
 				?><form action="?page=jadwal_ruangkelas&mode=input" method="post"><?php
 			}
 			?>
 
  	        <table border="0" width="100%" cellpadding="0" cellspacing="0">
             <tr valign="top">
               <td><!--  start step-holder -->
                 <!--  end step-holder -->
                   <!-- start id-form -->
                   <table border="0" cellpadding="0" cellspacing="0"  id="id-form">
                     <tr>
                       <th valign="top">Siswa</th>
                       <td><select name="id_siswa" >
                       <?php
 					  $siswa=mysql_query("select * from data_siswa order by nama_siswa asc");
 					  while($row1=mysql_fetch_array($siswa)){
 					  ?>
                           <option value="<?php echo $row1['id_siswa'];?>" <?php if($row1['id_siswa']==$id_siswa){ echo 'selected';}?>><?php echo $row1['nama_siswa'];?> (<?php echo $row1['nis'];?>) </option>
 					  <?php
 					  }
 					  ?>
 
                         </select>
                       </td>
                       <td></td>
                     </tr>
 
                     <tr>
                       <th valign="top">Kelas</th>
                       <td><select name="id_kelas" >
                           <?php
 						  $kelas=mysql_query("select * from setup_kelas order by nama_kelas asc");
 						  while($row2=mysql_fetch_array($kelas)){
 						  ?>
 							  <option value="<?php echo $row2['id_kelas'];?>" <?php if($row2['id_kelas']==$id_kelas){ echo 'selected';}?>><?php echo $row2['nama_kelas'];?></option>
 						  <?php
 						  }
 						  ?>
 
                         </select>
                       </td>
                       <td></td>
                     </tr>
 
                     <tr>
                       <th>&nbsp;</th>
                       <td valign="top">
 					  		<input type="hidden" name="id_ruangan" value="<?php echo $_GET['id_ruangan'];?>">
 					  		<input type="submit" name="submit" onClick="return confirm('Apakah Anda yakin?')" value="" class="form-submit" />
                           	<input type="reset" value="" class="form-reset"  />
                       </td>
                       <td></td>
                     </tr>
                   </table>
                 <!-- end id-form  -->
               </td>
               <td><!--  start related-activities -->
               </td>
             </tr>
             <tr>
               <td><img src="images/shared/blank.gif" width="695" height="1" alt="blank" /></td>
               <td></td>
             </tr>
         	</table>
 			</form>
 
 		    <p><em>* Satu siswa hanya untuk Satu Ruang Kelas</em>
               <!--  start product-table ..................................................................................... -->
         </p>
 		<p>&nbsp;</p>
 
 
 		<?php
 		//************awal paging************//
 		$query=mysql_query("select * from tbl_ruangan ruangan, setup_kelas kelas, data_siswa siswa where ruangan.id_kelas=kelas.id_kelas and ruangan.id_siswa=siswa.id_siswa order by id_ruangan asc");
 		$get_pages=mysql_num_rows($query); //dapatkan jumlah semua data
 
 		echo "<hr>entries = $entries<hr>";
 		if ($get_pages>$entries)  //jika jumlah semua data lebih banyak dari nilai awal yang diberikan
 		{
 			?>Halaman : <?php
 			$pages=1;
 			while($pages<=ceil($get_pages/$entries))
 			{
 				if ($pages!=1)
 				{
 					echo " | ";
 				}
 			?>
 			<!--Membuat link sesuai nama halaman-->
 			<a href="?page=jadwal_ruangkelas&halaman=<?php echo ($pages-1); ?> " style="text-decoration:none"><font size="2" face="verdana" color="#009900"><?php echo $pages; ?></font></a>
 			<?php
 			$pages++;
 			}
 
 		}else{
 			$pages=1;
 		}
 
 		//**************akhir paging*****************//
 		?>
 		</font>
 		<?php
 		$page=(int)$_GET['halaman'];
 		$offset=$page*$entries;
 
 		//menampilkan data dengan menggunakan limit sesuai parameter paging yang diberikan
 		$result=mysql_query("select * from tbl_ruangan ruangan, setup_kelas kelas, data_siswa siswa where ruangan.id_kelas=kelas.id_kelas and ruangan.id_siswa=siswa.id_siswa order by id_ruangan asc limit $offset,$entries"); //output
 		?>
 
 	    <form id="mainform" action="">
         <table class="table">
         <tr>
             <td><a href="">Nomor</a><td>
             <td><a href="">Nama Siswa</a><td>
             <td><a href="">NIS</a><td>
             <td><a href="">Kelas</a><td>
             <td><a href="">Aksi</a><td>
         </tr>
         <?php
 		$no=0;
 		while($row=mysql_fetch_array($result)){
 		?>
 		<tr class="table">
             <td><?php echo $offset=$offset+1;?></td>
             <td><?php echo $row['nama_siswa'];?></td>
             <td><?php echo $row['nis'];?></td>
             <td><?php echo $row['nama_kelas'];?></td>
             <td class="options-width">
             <a href="?page=jadwal_ruangkelas&mode=delete&id_ruangan=<?php echo $row['id_ruangan'];?>" onclick="return confirm('Apakah Anda yakin?')" title="Delete" class="icon-2 info-tooltip"></a>
             <a href="?page=jadwal_ruangkelas&mode=edit&id_ruangan=<?php echo $row['id_ruangan'];?>" title="Edit" class="icon-5 info-tooltip"></a>
             </td>
         </tr>
 		<?php
 		}
 		?>
         </table>
 		TOTAL DATA : <?php echo $get_pages;?>
         <!--  end product-table................................... -->
         </form>
 
 
 
 	<div class="clear"></div>
 
     </div>
     <!--  end content-table-inner ............................................END  -->
     </td>
     <td id="tbl-border-right"></td>
 </tr>
 <tr>
     <th class="sized bottomleft"></th>
     <td id="tbl-border-bottom">&nbsp;</td>
     <th class="sized bottomright"></th>
 </tr>
 </table>