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

	$getNvsStateQuery="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='NVS' group by kn.state_id order by s.state_name";	

	$sqlNvsState=$db->prepare($getNvsStateQuery);
	$sqlNvsState->execute();

	$nvsStateDataArray = array();
	while($rowNvsState=$sqlNvsState->fetch()){	
		$state_id= $rowNvsState['state_id'];
		$nvs_count= $rowNvsState['count'];
		$state_name = $rowNvsState['state_name'];
		$state_slug = $rowNvsState['state_slug'];
		$state_image = $rowNvsState['image_icon'];
		
		$nvsStateArray=array("state_id"=>$state_id, "state_name"=>$state_name, "nvs_count"=>$nvs_count, "state_slug"=>$state_slug, "state_image"=>$state_image);
		$nvsStateDataArray[]=$nvsStateArray;
	}	

	echo json_encode($nvsStateDataArray , TRUE);

?>