<?php
include "config.php";

header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');

$getEntranceExams="SELECT e.exam_id, e.exam_name, e.url_slug, c.img_icon, s.image_icon FROM sp_exam AS e LEFT JOIN sp_exam_category AS c ON c.cat_id=e.cat_id LEFT JOIN sp_states as s ON s.state_id=e.state_id LEFT JOIN sp_exam_links as l ON l.exam_id=e.exam_id WHERE e.cat_id=27 AND l.entity_id IN (7,8) Group BY e.exam_id ORDER BY l.update_date DESC";
$sqlEnt=$db->prepare($getEntranceExams);
$sqlEnt->execute();

$entArrayData = array();

while($rowEnt=$sqlEnt->fetch()){
	if($rowEnt['img_icon']!=''){ 
		$image = $rowEnt['img_icon']; 
	} else { 
		$image = $rowEnt['image_icon']; 
	}
	$entArray=array("exam_id"=>$rowEnt['exam_id'], "exam_name"=>$rowEnt['exam_name'], "url_slug"=>$rowEnt['url_slug'], "img_icon"=>$image);
	$entArrayData[]=$entArray;
}

$mainarray[]=array("entranceTest"=>$entArrayData);

echo json_encode($mainarray);
?>