<?php

error_reporting(-1);
ini_set('display_errors', 'On');

header('Content-Type: application/json');	
include 'config.php';

 $examIDq = "SELECT DISTINCT(exam_id) FROM sp_exam_links WHERE status!='0'
ORDER BY update_date  DESC LIMIT 8";

$sqlexam = $db->prepare($examIDq);
$sqlexam->execute();

$sqlexamData = $sqlexam->fetchAll();

//echo "<pre> Data : ".print_r($sqlexamData,TRUE)."</pre>";

$examId = '';
for ($i=0; $i <count($sqlexamData); $i++) { 

$examId .= 	$sqlexamData[$i]['exam_id'].',';
}

$examIDs = rtrim($examId,',');

 $query="SELECT t1.exam_id, t1.exam_name, t1.post_name, t1.url_slug, t1.cat_id, t1.state_id, t1.fee_desc, t1.physical, t1.total_vacancy, t1.sp_exam_id, t1.off_web_link, t1.display_order, t1.sp_id, t1.status,t1.add_date,t2.name,t2.img_icon FROM sp_exam AS t1
    LEFT JOIN sp_exam_category AS t2 on t2.cat_id=t1.cat_id WHERE t1.status!='0' and t1.exam_id IN (".$examIDs.")";

$sql=$db->prepare($query);
$sql->execute();

$mainarray=array();

while($row=$sql->fetch()){	

$id=$row['exam_id'];
$exam=$row['exam_name'];
$post=$row['post_name'];
$display=$row['display_name'];

$queryLinks ="SELECT display_text,links,enti_id FROM sp_exam_links As sel
        LEFT JOIN sp_exam_entity As e1 ON e1.id=sel.enti_id
        WHERE exam_id=$id";

$sqleLinks=$db->prepare($queryLinks);
$sqleLinks->execute();

$linksArray = array();

while( $roweLinks = $sqleLinks->fetch() ){	
   

   $linksArray[] = array( 'enti_id'=>$roweLinks['enti_id'] , 'display_text'=>$roweLinks['display_text'] , 'links'=>$roweLinks['links'] ); 
}

$array=array("exam_id"=>$id,"exam_name"=>$exam,"post_name"=>$post,"display_name"=>$display,'links'=>$linksArray);
$mainarray[]=$array;

}

//print_r($mainarray);

echo json_encode($mainarray);


?>