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

$json = file_get_contents('php://input');
$data = json_decode($json);
$slug = $data->state;

$getNVSQuery = "select kn.name, kn.address, kn.pincode, kn.official_website_link, kn.online_apply_link, kn.online_fee_link, kn.result_link, kn.addmission_guidelines, kn.addmission_details, s.state_name, c.city from sp_kvs_navodya as kn INNER JOIN sp_states as s ON s.state_id=kn.state_id LEFT JOIN sp_city as c on c.city_id=kn.city_id where kn.status='1' and kn.type='NVS' and s.state_slug='$slug' order by kn.name";

$getNVSData = $db->prepare($getNVSQuery);
$getNVSData->execute();

	$data = array();
	
	while($nvsRes=$getNVSData->fetch()){
		$nestedData = array();
		$nestedData["image_icon"] = 'navodaya_vidyalaya.png';
		$nestedData["name"] = $nvsRes['name'];
		$nestedData["address"] = $nvsRes['address'];
		$nestedData["pincode"] = $nvsRes['pincode'];
		$nestedData["state_name"] = $nvsRes['state_name'];
		$nestedData["city"] = $nvsRes['city'];
		$nestedData["official_website_link"] = $nvsRes['official_website_link'];
		$nestedData["online_apply_link"] = $nvsRes['online_apply_link'];
		$nestedData["online_fee_link"] = $nvsRes['online_fee_link'];
		$nestedData["result_link"] = $nvsRes['result_link'];
		$nestedData["addmission_guidelines"] = $nvsRes['addmission_guidelines'];
		$nestedData["addmission_details"] = $nvsRes['addmission_details'];
		
		$data[] = $nestedData;
	}

	$json_data = array($data);
				
	echo json_encode($json_data);

?>