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

	$getKvsStateQuery="SELECT kn.state_id, count(kn.id) as count, s.state_name, s.image_icon, s.state_slug FROM sp_kvs_navodya as kn INNER JOIN sp_states as s ON s.state_id=kn.state_id WHERE kn.type='KVS' group by kn.state_id order by s.state_name";	

	$sqlKvsState=$db->prepare($getKvsStateQuery);
	$sqlKvsState->execute();

	$kvsStateDataArray = array();
	while($rowKvsState=$sqlKvsState->fetch()){	
		$state_id= $rowKvsState['state_id'];
		$kvs_count= $rowKvsState['count'];
		$state_name = $rowKvsState['state_name'];
		$state_slug = $rowKvsState['state_slug'];
		$state_image = $rowKvsState['image_icon'];
		
		$kvsStateArray=array("state_id"=>$state_id, "state_name"=>$state_name, "kvs_count"=>$kvs_count, "state_slug"=>$state_slug, "state_image"=>$state_image);
		$kvsStateDataArray[]=$kvsStateArray;
	}	

	echo json_encode($kvsStateDataArray , TRUE);

?>