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

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

	$kvs_details = "SELECT  kn.latitude,kn.longitude,kn.address,kn.id,kn.url_slug , kn.type, kn.name, kn.state_id, s.state_name,s.state_slug,s.image_icon,s.latitude as s_lat,s.longitude as s_lon, kn.city_id, c.city, kn.pincode, kn.address, kn.official_website_link, kn.online_apply_link, kn.online_fee_link, kn.result_link, kn.addmission_guidelines, kn.addmission_details, kn.important_emails, kn.important_phones FROM sp_kvs_navodya as kn LEFT 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.url_slug='$slug' ";
	$kvs_details = $db->prepare($kvs_details);
	$kvs_details->execute();
	$rCount = $kvs_details->rowCount();
	$kvs_data = array();
	if($rCount > 0){
		while($kvsdata = $kvs_details->fetch()) {
			$kvsarry = array(
				"status" => 1,
				"latitude" => $kvsdata['latitude'],
				"longitude" => $kvsdata['longitude'],
				"id" => $kvsdata['id'],
				"type" => $kvsdata['type'],
				"url_slug" => $kvsdata['url_slug'],
				"name" => $kvsdata['name'],
				"state_name" => $kvsdata['state_name'],
				"s_lat" => $kvsdata['s_lat'],
				"s_lon" => $kvsdata['s_lon'],
				"city" => $kvsdata['city'],
				"pincode" => $kvsdata['pincode'],
				"address" => $kvsdata['address'],
				"online_fee_link" => $kvsdata['online_fee_link'],
				"official_website_link" => $kvsdata['official_website_link'],
				"online_apply_link" => $kvsdata['online_apply_link'],
				"result_link" => $kvsdata['result_link'],
				"addmission_guidelines" => $kvsdata['addmission_guidelines'],
				"important_emails" => $kvsdata['inportant_emails'],
				"important_phones" => $kvsdata['important_phones'],
				"addmission_details" => $kvsdata['addmission_details']
			);
			$kvs_data[] = $kvsarry;
		}
	} else {
		$kvsarry=array("status"=>0, "message"=>"No data found");
		$kvs_data[] = $kvsarry;
	}

	$datarr = array("kvsdata" => $kvs_data);
	echo json_encode($datarr, TRUE);
	?>