<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";


$institute_id=isset($_GET['institute']) ? $_GET['institute'] : "";

$query="SELECT DISTINCT(t1.state_id) as sid,t2.state_name,t2.state_slug,t2.image_icon FROM sp_institutions as t1
LEFT JOIN sp_states as t2 on t2.state_id=t1.state_id
LEFT JOIN sp_institutions_category as ic on ic.id=t1.category_id
WHERE t1.state_id!='0' and t1.category_id='$institute_id' ORDER by t1.display_order 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("institute_id"=>$institute_id,"state_id"=>$state_id,"state_name"=>$state_name,"image_icon"=>$image_icon);
$mainarray[]=$array4;

}	
$array = array("data"=>$mainarray);
$main[] = $array;
echo json_encode($main , TRUE);

?>