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

$keyword=explode(" ",$_REQUEST['exam']);

$searchterm = "%".$keyword[0]."%";
$searchterm1 = "%".$keyword[1]."%";
// echo "SELECT t1.exam_id, t1.exam_name,t1.exam_summary,t1.cat_id,t2.img_icon,t2.name,t1.url_slug,ee.name as enti 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
// 								LEFT JOIN sp_exam_links as el on el.exam_id=t1.exam_id	
// 								LEFT JOIN sp_exam_entity as ee on ee.id=el.entity_id	
// 								WHERE (t1.exam_name LIKE '%".$searchterm."%') OR (t1.exam_summary LIKE '%".$_REQUEST['exam']."%') GROUP BY t1.exam_id";			
$query = $db->query("SELECT t1.exam_id, t1.exam_name,t1.exam_summary,t1.cat_id,t2.img_icon,t3.image_icon,t3.image_icon,t2.name,t1.url_slug,ee.name as enti 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
								LEFT JOIN sp_exam_links as el on el.exam_id=t1.exam_id	
								LEFT JOIN sp_exam_entity as ee on ee.id=el.entity_id	
								WHERE (t1.exam_name LIKE '%".$searchterm."%') OR (t1.exam_summary LIKE '%".$_REQUEST['exam']."%') OR (ee.name LIKE '%".$_REQUEST['exam']."%') OR (ee.name LIKE '%".$searchterm."%') OR (t1.exam_name LIKE '%".$_REQUEST['exam']."%') AND t1.status!='0' AND el.status!='0'  GROUP BY t1.exam_id");
			
			while ( $row = $query->fetch() ) {
				
					$exam=$row['exam_name'];
					$label =  $row['name'];
					if($row['cat_id']  == 0) {
						
					   $label =  $row['enti'];
					}
					$mainarray[] = array(
										'label' => $row['exam_name'].' exam ',
										'url_slug'=>$row['url_slug'],
										'id' => $row['exam_id'],
										'img' => $row['img_icon'],
										'image' => $row['image_icon'],
										'type' =>'exam',
										'value' => $row['exam_name'].' exam  in '.$label,
										);
			
			}


$query2 = $db->query("SELECT k.id,k.name,k.type,k.state_id,k.city_id from sp_kvs_navodya as k where k.name LIKE '%".$_REQUEST['exam']."%' and k.type='kvs'");
			
			while ( $row2 = $query2->fetch() ) {
				
					
					$mainarray[] = array(
										'label' => $row2['name'],
										'url_slug'=>'kendriya_vidyalaya_sangathan',
										'id' => $row2['state_id'],
										'id2' => $row2['city_id'],
										'img' => 'entrance_exams.png',
										'type' =>'kvs',
										'value' => $row2['name'],
										);
			
			}

$query3 = $db->query("SELECT n.id,n.name,n.type,n.state_id,n.city_id from sp_kvs_navodya as n where n.name LIKE '%".$_REQUEST['exam']."%' and n.type='nvs'");
			
			while ( $row3 = $query3->fetch() ) {
				
					
					$mainarray[] = array(
										'label' => $row3['name'],
										'url_slug'=>'navodaya_vidyalaya_samiti',
										'id' => $row3['state_id'],
										'id2' => $row3['city_id'],
										'img' => 'entrance_exams.png',
										'type' =>'nvs',
										'value' => $row3['name'],
										);
			
			}

		echo json_encode($mainarray);	
	 
?>