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

$type=$_REQUEST['type'];
if($type=="kvs" OR  $type=="nvs"){
$query="SELECT DISTINCT(t1.state_id) as sid,t2.state_name,t2.image_icon FROM sp_kvs_navodya as t1 
LEFT JOIN sp_states as t2 on t2.state_id=t1.state_id WHERE t1.type='$type' ORDER BY t1.add_date DESC";	
}
elseif($type=="exam"){
$query="SELECT DISTINCT(t1.state_id) as sid, t1.state_name, t1.image_icon,t2.state_id FROM sp_states as t1
LEFT JOIN sp_exam as t2 on t2.state_id=t1.state_id WHERE t2.state_id!='null' ORDER BY t2.add_date DESC";		
}	

$sql=$db->prepare($query);
$sql->execute();

while($row=$sql->fetch()){	
$state_name= $row['state_name'];
$state_id= $row['sid'];
$image_icon= $row['image_icon'];


$array4=array("state_id"=>$state_id,"state_name"=>$state_name,"image_icon"=>$image_icon);
$mainarray[]=$array4;
}	

echo json_encode($mainarray , TRUE);