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

	$getKvsStateQuery="SELECT s.state_id, s.state_name, s.state_slug, s.image_icon, s.state_code FROM sp_states as s WHERE s.state_id!='' order by s.state_name";	

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

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

	echo json_encode($kvsStateDataArray , TRUE);

?>