📁 File Manager

Dosya Düzenle: getuser.php

if ($_GET['course'] != "n") {
   $where = "course='$q'";
} else {
   $where = "1";
}

if ($_GET['semester'] != "n") {
   $where1 = " semester='$q1'";
} else {
   $where1 = "1";
}
 
 if ($_GET['department'] != "n") {
   $where2 = " department='$q2'";
} else {
   $where2 = "1";
}
 if ($_GET['type'] != "n") {
   $where3 = " type='$q3'";
} else {
   $where3 = "1";
}

include'connect.php';

$sql="SELECT * FROM question WHERE ".$where." AND ".$where1." AND ".$where2." AND ".$where3."  order BY department ";

$result = mysqli_query($con,$sql); $n=1;?>
        <div class="table-responsive">
    	 <table   class=" table" border='0' > 
         <div  >
              <?php echo " <tr> <td align='center'><b><font size='2'>Slno</font></b></td> <td align='center' ><b>Course</b></td><td align='center' ><b>Paper</b></td><td align='center'><b>Year</b></td> <td align='center'><b>Semester</b></td> <td align='center' ><b>General/Major</b></td> <td align='center' ><b>Department</b></td> <td></td></tr>"; 
    	while($row = mysqli_fetch_array($result)) { 
    		echo "<tr>"; 
    		echo "<td align='center'>" . $n . "</td>"; 
    		echo "<td align='center'>" . $row['course'] . "</td>";
echo "<td align='center'>" . $row['paper'] . "</td>"; 
echo "<td align='center'>" . $row['year'] . "</td>"; 
    		echo "<td align='center'>" . $row['semester'] . "</td>"; 
			echo "<td align='center'>" . $row['type'] . "</td>";
			echo "<td align='center'>" . $row['department'] . "</td>";
			?>
					
			<td> 
            <a href="<?php echo $row['link']; ?>">
<font color="red" size= "2">Download Now  </font>         
 </a> 
            </td>
            <?php
    		echo "</tr>";
			$n=$n+1; }

mysql_close($con); 
			?> 
    		</table> 
    		</div></div>

İptal