View difference between Paste ID: WdF4HggA and yCjFMttK

 <?php
 /*
 ganti query dengan mysql_query()
 fetch dengan mysql_fetch_array()
 
 */
 extract($_POST);
 //$semester='ganjil';
 $semester=trim(strtolower($semester));
 if($semester!='genap'&&$semester!='ganjil')
 {
 	die('salah penginputan nilai semester ='.$semester);
 }
-$q=mysql_query($sql)or die(mysql_error());
+
 <h1><?=$semester;?></h1>
 <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
                 <thead>
                     <tr>
 						<th>NAMA DOSEN</th>
                         <th>PEMBIMBING 1</th>
-while($r=mysql_fetch_array($q))
+
                     </tr>
                 </thead>
                 <tbody>
 
 <?php
 
 
 $sql="select nip, nama, jabatan from dosen order by nama asc";
-	       {
+$q=query($sql);
 $aCat= array();
 $aData=array(
 	array('name'=>'pembimbing 1'),
-		$q2=mysql_query($sql)or die(mysql_error());
+
-		$r2=mysql_fetch_array($q2);
+
 
 while($r=fetch($q))
-		     else if ($tahun_ajaran<>'')
+
-		     {
+
 	$field=array('nip1','nip2' );
 	$nip=$r['nip'];
 	$num=array();
-		     $q2=mysql_query($sql)or die(mysql_error());
+
-		     $r2=mysql_fetch_array($q2);
+
 	  	if ($semester<>'')
-		     }
+	    {
-                       else
+
-		          {
+
 		group by $f";
 		$q2=query($sql);
 		$r2=fetch($q2);
-		              $q2=mysql_query($sql)or die(mysql_error());
+
-		              $r2=mysql_fetch_array($q2);
+
-		              $num[]=$r2['c'];
+		elseif($tahun_ajaran<>'')
-		         }
+		{
 		     $sql="select count($f) c  from tugas_akhir
 		     where $f like '$nip' and left( tgl_ajukan_judul, 4 ) like '$tahun_ajaran'
 		     group by $f";
 		     $q2=query($sql);
 		     $r2=fetch($q2);
 		    $num[]=$r2['c'];
 		}
         else
 		{
 		          $sql="select count($f) c  from tugas_akhir
 		              where $f like '$nip'
 		              group by $f";
 		              $q2=query($sql);
-			<?php  }  ?>
+		     $r2=fetch($q2);
 		    $num[]=$r2['c'];
 		}
 
 	}
 
 		$aData[0]['data'][]=intval($num[0]);
 		$aData[1]['data'][]=intval($num[1]);
 		$aCat[]=$r['nama'];
 ?>
 
 			<TR>
   <TD><?=$r['nama'];?></td>
   <TD class='td1a'><center><?=intval($num[0]);?></center></td>
   <TD class='td1a'><center><?=intval($num[1]);?></center></td>
 
 
 </tr>
 			<?php
 }  ?>
 
 
 
 
 
 			</tbody>
             </table>