<?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() ) {
				$cat = $row3['name'];
		          $mainarray[]= array(
									  'label'=>$row3['name'].' - find all exam related to '.$cat,
									  'url_slug'=>$row3['url_slug'],
									  'id'=>$row3['cat_id'],
									  'type'=>'category',
									  'value' => $row3['name'].' in categories ',
									 );
			      }
			
			$query = $db->query("SELECT t1.exam_id, t1.exam_name,t1.cat_id,t1.state_id,t2.name,t3.state_name,t1.url_slug,t1.status 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' AND t1.status='1'");
			
			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'].' exam ',
										'url_slug'=>$row['url_slug'],
										'id' => $row['exam_id'],
										'type' =>'exam',
										'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() ) {
				
				   $mainarray[]= array(
									   'label'=>$row2['name'],
									   'url_slug'=>$row2['entity_id'],
									   'id'=>$row2['id'],
									   'type'=>'entity',
									   'value' => $row2['name'] . ' of ' . $exam,
									  );
				  }

			$query4 = $db->query("SELECT kn.id,kn.name,kn.state_id,kn.city_id FROM sp_kvs_navodya as kn
                        		  WHERE kn.name LIKE '$searchTerm' and kn.type='kvs'");
								  
			while ( $row4 = $query4->fetch() ) {
				
				   $mainarray[]= array(
									   'label'=>$row4['name'],
									   'url_slug'=>'kendriya-vidyalaya-sangathan',
									   'id'=>$row4['state_id'],
									   'id2' =>$row4['city_id'],
									   'type'=>'kvs',
									   'value' => $row4['name'].' in KVS ',
									  );
				  }

			$query5 = $db->query("SELECT n.id,n.name,n.state_id,n.city_id FROM sp_kvs_navodya as n
                        		  WHERE n.name LIKE '$searchTerm' and n.type='nvs'");
								  
			while ( $row5 = $query5->fetch() ) {
				
				   $mainarray[]= array(
									   'label'=>$row5['name'],
									   'url_slug'=>'navodaya-vidyalaya-samiti',
									   'id'=>$row5['state_id'],
									   'id2' =>$row5['city_id'],
									   'type'=>'nvs',
									   'value' => $row5['name'].' in NVS ',
									  );
				  }	  
							  
			}
							  //$main[]=$mainarray;
	
		echo json_encode($mainarray);	
	 
?>