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

$json = file_get_contents('php://input');
$data = json_decode($json);
$slug = $data->category;

//$slug = $_REQUEST["slug"];

/** Check is slug is not empty */
if(isset($slug)){
	/** query to get category details */
	$query="select ec.cat_id, ec.name, ec.img_icon, ec.full_name from sp_exam_category as ec WHERE ec.url_slug='$slug'";
	$sql=$db->prepare($query);
	$sql->execute();
	$rCount = $sql->rowCount();
	
	/** check if category details is not empty */
	if($rCount > 0){
		while($row=$sql->fetch()){
			$cat=$row['cat_id'];
			$name=$row['name'];
			$full_name=$row['full_name'];
			$img= '/images/'. $row['img_icon'];
			
			/**
			 * query to get all exams of single category
			 * @param - category id from above query
			 */
			$query2="select e.exam_name, e.exam_id, e.url_slug, e.exam_summary,  e.add_date from sp_exam as e where e.cat_id='$cat' order by e.add_date DESC";
			$sql2=$db->prepare($query2);
			$sql2->execute();
			
			$examListArray=array();
			while($row=$sql2->fetch()){
				$exam_id=$row['exam_id'];
				$examname=$row['exam_name'];
				$url_slug=$row['url_slug'];
				$exam_summary=$row['exam_summary'];
				$addOn = date('d M Y',strtotime($row['add_date']));
				$txt_length= 100;
				$limit_summary = substr(strip_tags($exam_summary), 0, $txt_length);

				$main=array("examID"=>$exam_id,"exam_name"=>$examname,"url_slug"=>$url_slug,"exam_summary"=>$limit_summary,"add_date"=>$addOn);
				$examListArray[]=$main;	
			}

			
			$array=array("status"=>1, "message"=>"found", "categoryID"=>$cat, "category_name"=>$name, "Img_icon"=>$img, "full_name"=>$full_name, "exam"=>$examListArray);
			$mainsub[]=$array;
		}
	} else {
		$array=array("status"=>0, "message"=>"No data found");
		$mainsub[]=$array;
	}
	//print_r($mainsub);

	echo json_encode($mainsub);
}
?>