<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";

$json = file_get_contents('php://input');
$data = json_decode($json);
$slug = $data->state;
//$slug = $_REQUEST["state"];

$getExamQuery = "select ex.exam_name, ex.url_slug, ex.state_id, s.image_icon, GROUP_CONCAT(ee.name) as entities from sp_exam as ex INNER JOIN sp_states as s ON s.state_id=ex.state_id LEFT JOIN sp_exam_links as el ON el.exam_id=ex.exam_id LEFT JOIN sp_exam_entity as ee ON ee.id=el.entity_id where ex.status='1' and s.state_slug='$slug' group by el.exam_id order by ex.exam_id desc";

$getExamData = $db->prepare($getExamQuery);
$getExamData->execute();

	$data = array();
	
	while($exRes=$getExamData->fetch()){
		$nestedData = array();
		$nestedData["image_icon"] = $exRes['image_icon'];
		$nestedData["exam_name"] = $exRes['exam_name'];
		$nestedData["entities"] = implode(',', array_unique(explode(',', $exRes['entities'])));
		$nestedData["url_slug"] = $exRes['url_slug'];
		
		$data[] = $nestedData;
	}

		$json_data = array($data);
				
		echo json_encode($json_data);

?>