<?php 
include("admin/include/config.inc.php");


$course_name=$_POST["course_name"];
$course_year=$_POST["course_year"];
$course_semester=$_POST["course_semester"];
$course_papercode=$_POST["course_papercode"];

//echo "select * from studentcorner WHERE coursename='".$course_name."' AND  semester='".$course_semester."' AND  papercode ='".$course_papercode."' AND  year ='".$course_year."' ";

if(!empty($course_name) && !empty($course_name)){
	$html='';

	$data_found=mysqli_fetch_array(mysqli_query($con,"select * from studentcorner WHERE coursename='".$course_name."' AND  semester='".$course_semester."' AND  papercode ='".$course_papercode."' AND  year ='".$course_year."' "));

	if(isset($data_found)){
		$i=1;		
		while($value = mysqli_fetch_array(mysqli_query($con,"select * from studentcorner WHERE coursename='".$course_name."' AND  semester='".$course_semester."' AND  papercode ='".$course_papercode."' AND  year ='".$course_year."' "))) {
			print_r($value);
			$html.='<tr>';
				$html.='<td>'. $i.'</td>';
				$html.='<td>'.$value['coursename'].'</td>';
				$html.='<td>'.$value['title'].'</td>';
				$html.='<td><a href="http://jcboseedu.org/viewer.php?utm_f='.$value['filecode'].'" class="btn btn-sm btn-primary" target="_blank">Download</a></td>';
			$html.='</tr>';
			
			$i++;
		}
	}else{
		$html='<tr><td colspan="4" style="text-align: center;">No data found</td></tr>';
	}
}else{
	$html='<tr><td colspan="4" style="text-align: center;">No data found</td></tr>';
}


echo $html;
//$return['html']=$html;

//header('Content-Type: application/json; charset=utf-8');

//echo json_encode($return);
?>