<?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);
if (isset($_REQUEST['category'])) {
$cat = $_REQUEST['category'];

$query="select cat_id,name,img_icon,full_name,url_slug from sp_exam_category where url_slug!='$cat'";
$sql=$db->prepare($query);
$sql->execute();

while($row=$sql->fetch()){
$cat=$row['cat_id'];
$name=$row['name'];
$img=$row['img_icon'];
$full_name=$row['full_name'];
$url_slug=$row['url_slug'];


$query2="select e.exam_name,e.exam_id from sp_exam as e
where e.cat_id='$cat'";
$sql2=$db->prepare($query2);
$sql2->execute();

$mainsub2=array();
while($row=$sql2->fetch()){
$exam_id=$row['exam_id'];
$examname=$row['exam_name'];

$query3="select el.entity_id,el.id,ee.name,el.display_text,el.links from sp_exam_links as el
Left join sp_exam_entity as ee on ee.id=el.entity_id
where el.exam_id='$exam_id'";
$sql3=$db->prepare($query3);
$sql3->execute();

}

$array=array("category_id"=>$cat,"category_name"=>$name,"full_name"=>$full_name,"Img_icon"=>$img,"url_slug"=>$url_slug);
$mainsub[]=$array;
}
//print_r($mainsub);

echo json_encode($mainsub);
}
?>