<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
/* ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); */
include 'config.php';
$mainarray=array();
$searchTerm = "%" . $_REQUEST['term']. "%"; 
    $query = $db->query("SELECT t1.exam_id, t1.exam_name, t2.name FROM sp_exam as t1
LEFT JOIN sp_exam_category as t2 on t2.cat_id=t1.cat_id	
	WHERE t1.exam_name LIKE '$searchTerm' ");
	while ($row = $query->fetch()) {
		
		$query2 = $db->query("SELECT tab1.id,tab1.name FROM sp_exam_entity as tab1 WHERE tab1.name LIKE '$searchTerm' ");
			while ($row2 = $query2->fetch()) {
		 $mainarray[]=array(
			"label"=>$row2['name'],
			"id"=>$row2['id'],
			"type"=>"entity",
			'value' => $row2['name'] . ' in ' . $row['name'],
		);
			  };
		
		$query3 = $db->query("SELECT t2.cat_id, t2.name FROM sp_exam_category as t2 WHERE t2.name LIKE '$searchTerm' ");
			while ($row3 = $query3->fetch()) {
		 $mainarray[]=array(
			"label"=>$row3['name'],
			"id"=>$row3['cat_id'],
			"type"=>"category",
			'value' => $row3['name'] . ' in ' . $row['name'],
		);
			  };
			 
	
        $mainarray[] = array (
            'label' => $row['exam_name'],
            'id' => $row['exam_id'],
			"type" =>"exam",
            'value' => $row['exam_name'] . ' in ' . $row['name'],
        );
    }
	
		$main[]=$mainarray;
		echo json_encode($main);
	 

?>