<?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();
	if ( isset($_REQUEST['term']) ) {
		
			$searchTerm = "%" . $_REQUEST['term']. "%"; 
			
			
			$query3 = $db->query("SELECT t2.cat_id, t2.name,t2.url_slug FROM sp_exam_category as t2
   		                        WHERE t2.name LIKE '$searchTerm' ");
								
			while ( $row3 = $query3->fetch() ) {
				
		          $mainarray[]= array(
									  'label'=>$row3['name'],
									  'url_slug'=>$row3['url_slug'],
									  'id'=>$row3['cat_id'],
									  'type'=>'category',
									  'entity_type'=>'null',
									  'value' => $row3['name'].' in categories ',
									 );
			      }
			
			$query = $db->query("SELECT t1.exam_id, t1.exam_name,t1.cat_id,t1.url_slug,t1.state_id,t2.name,t3.state_name FROM sp_exam as t1
								LEFT JOIN sp_exam_category as t2 on t2.cat_id=t1.cat_id	
								LEFT JOIN sp_states as t3 on t3.state_id=t1.state_id	
								WHERE t1.exam_name LIKE '$searchTerm' order by t1.exam_id desc");
			
			while ( $row = $query->fetch() ) {
				
					$exam=$row['exam_name'];
					$label =  $row['name'];
					if($row['cat_id']  == 0) {
						
					   $label =  $row['state_name'];
					}
					$mainarray[] = array(
										'label' => $row['exam_name'],
										'url_slug'=>$row['url_slug'],
										'id' => $row['exam_id'],
										'type' =>'exam',
										'entity_type'=>'null',
										'value' => $row['exam_name'].' exam  in '.$label,
										);
			
			}
			$query2 = $db->query("SELECT tab1.id,tab1.name,tab1.entity_id FROM sp_exam_entity as tab1
                        		  WHERE tab1.name LIKE '$searchTerm' ");
								  
			while ( $row2 = $query2->fetch() ) {
				 $id=$row2['id'];
				 $type='pre';
				 if($id == '5' || $id == '4'){
					 $type='post';
				 }
				
				   $mainarray[]= array(
									   'label'=>$row2['name'],
									   'url_slug'=>$row2['entity_id'],
									   'id'=>$row2['id'],
									   'type'=>'entity',
									   'entity_type'=>$type,
									   'value' => $row2['name'] . ' of ' . $exam,
									  );
				  }
							  
			
							  $main[]=$mainarray;
	
		echo json_encode($main);	
	 
} else {
	
}
?>