<?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);

$slug=$_REQUEST['slug'];
if(isset($_REQUEST['slug'])){
$query1="SELECT id, name,entity_id, status FROM sp_exam_entity WHERE entity_id='$slug'";	
$sql=$db->prepare($query1);
$sql->execute();
$row=$sql->fetch();
$cat= $row['name'];
$ide=$row['id'];
$entity_id=$row['entity_id'];

$query="SELECT cat_id,name,url_slug,img_icon FROM sp_exam_category";
$sql2=$db->prepare($query);
$sql2->execute();

$mainSub = array();
while($row=$sql2->fetch()){	
$category=$row['name'];
$cid=$row['cat_id'];
$slu=$row['url_slug'];
$img_icon="/images/".$row['img_icon'];


$query3="SELECT t3.name,t1.exam_id,t1.links,t2.cat_id,t2.url_slug,t1.description,t1.status,t1.display_text,t2.exam_name,t1.status,t1.date_type,t1.date 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 entity_id='$ide'";
$sql3=$db->prepare($query3);
$sql3->execute();

$mainSub3 = array();
while($row3=$sql3->fetch()){	
$link2=$row3['links'];
$exam_name=$row3['exam_name'];
$display_text=$row3['display_text'];
$status=$row3['status'];
$url=$row3['url_slug'];
$date_type=$row3['date_type'];
$date=$row3['date'];
$array1=array("link"=>$link2,"exam_name"=>$exam_name,"displaytext"=>$display_text,"url_slug"=>$url,"status"=>$status,"date_type"=>$date_type,"date"=>$date);

$mainSub3[]=$array1;
}
$main=array("category"=>$category,"slug"=>$slu,"img_icon"=>$img_icon,"link"=>$mainSub3);


$mainSub[]=$main;
}

$array4 = array("id"=>$ide,"entity_id"=>$entity_id,"entity"=>$cat,"exams"=>$mainSub);
$mainarray[] = $array4;
	
//print_r($mainarray);
}
echo json_encode($mainarray);

?>