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

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$arrayIds = array(2);
$enti_id=implode(',', $arrayIds);

$query1="SELECT DISTINCT( t2.cat_id ),t3.name,t3.url_slug FROM sp_exam_links as t1 LEFT JOIN sp_exam as t2 ON t1.exam_id=t2.exam_id LEFT JOIN sp_exam_category t3 ON t2.cat_id=t3.cat_id WHERE t2.cat_id!=0 and t1.entity_id in($enti_id) ORDER BY t1.update_date DESC";	
$sql=$db->prepare($query1);
$sql->execute();


while($row=$sql->fetch()){	
$cat= $row['name'];
$cid= $row['cat_id'];
$slu= $row['url_slug'];

$query="SELECT t3.name,t1.exam_id,t1.links,t2.cat_id,t1.description,t1.status,t1.display_text,t2.exam_name,t3.img_icon,t2.url_slug FROM sp_exam_links as t1
LEFT JOIN sp_exam as t2 ON t1.exam_id=t2.exam_id
LEFT JOIN sp_exam_category as t3 ON t2.cat_id=t3.cat_id where t2.cat_id='$cid'and t1.entity_id in($enti_id)
ORDER BY t1.update_date DESC limit 0,3";
$sql2=$db->prepare($query);
$sql2->execute();

$mainSub = array();
while($row=$sql2->fetch()){	
$link=$row['links'];
$desc=$row['description'];
$status=$row['status'];
$examname=$row['exam_name'];
$status=$row['status'];
$img_icon=$row['img_icon'];
$url_slug=$row['url_slug'];
$main=array("link"=>$link,"description"=>$desc,"exam"=>$row['display_text']." - ".$examname,"status"=>$status,"url_slug"=>$url_slug);
$mainSub[]=$main;
}

$array4=array("cat_id"=>$cid,"category"=>$cat,"url_slug"=>$slu,"img_icon"=>$img_icon,"links"=>$mainSub);
$a[]=$array4;


}		

$mainarray=array("id"=>$arrayIds,"data"=>$a);
//print_r($mainarray);

echo json_encode($mainarray);

?>